Query to List all records with Value from Mulitpe Tables

[PicoTTS]

Hi,

I am trying to combine data from 3 different tables into a query. The three tables are linked by the OrderNumber and have a seperate/unique ID's. I would like a query that essentially combines creates a list of the ID's for that given OrderNumber.



Thanks for your help in advance.

[ranman256]

use a UNION query. It must be done in SQL mode, because you cant use GUI design mode.


select [order#], [id], "tbl1" from table1
union
select [order#], [id], "tbl2" from table2
union
select [order#], [id], "tbl3" from table3

then make a query on the above query to sort them.