Joining data from multiple query tables

Joining data from multiple query tables

Hi there,

We've had to create multiple query tables to get around Zoho's inability to support multiple select statements in the same query.

These are working fine, but we want to now join all five of the data tables so we can show the data from all five in one report.

All five query tables only have one row and two columns (date and total columns) - we just want to include this row from each in a single report.

Appreciate any advice on how to do this.