How do I Merge Four Tables Together

[SteveI]

I have four tables, each with two fields Product and Price. Exch of the four table has different data in each of those fields and I would like to make one table with the fields Product and Price which will have four rows, one from each of the tables (this is all the date in all the tables, just one row in each table)



Can anyone tell me how this is done please? If it helps to explain the answer assume the tables are called Tbl1, Tbl2, Tbl3 and Tbl4. The primary key for each of the tables can ether be the same (Product) or have no key set at all if ths makes a difference.

Thanks in advance.

[pbaldy]

Try a UNION query:

SELECT Field1, Field2
FROM Table1
UNION ALL
SELECT Field1, Field2
FROM Table2
UNION ALL
...