I don�t have time to post a full reply here but the basic concept is this.
QuickBase can only do a report of a single table. So you need to coax data from your two tables into a single table.
The way to do that would be to set up a third table and then set up a saved a table to table copy which will copy all the records from one table into that third table and then do the same to copy the records from the second table into the third table.
So the idea would beat every time you wanted to do a consolidated report, you would delete all the records in the third table and then re-import from tables one and two.
This could all be combined into a single button to click which would do those three steps in one click.