report based on many SQL

[engnouna]

Hi
I am using the data report that comes with VB6,i want to include in my report records from 2 different SQL statement,in other words I want my report to contain the results of 2 queries executed on differents tables inside the same database.
For example I have a database containing 5 tables:
Patron,Seat,Source,Date,info
the first SQL statement queries data from the following tables:
Patron,Seat,Source
the second SQL statement queries data from the following tables:
Source,Date,Info

Can anyone guide me through the steps to include the 2 SQL statements results into my report?

Thanks

[binilmb]

I think its not possible. Better do it manually by assigning values to labels in the datareport