New To DWC and need help

Im trying to create a pie chart where it will show which companies have made requests using a form on our site. The form submits to a mysql table that records the user (idusr_ref which contains the id from the user_usr table) and other information related to the request. I want to be able to sum up the amount of each company's requests and show that in the pie chart. How can I do this when there are two tables involved?

Thanks in advance,
John

in your MySQL database you could create a view that uses a joined query to return the data from both tables as one result set. Then in DWC, use the view as the dat source.

see this page for more on creating views in MySQL
An_Introduction_to_MySQL_Views