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