Hi, I want to make a report that shows all the information in 2 tables. table one has processing info table two has packing info, they both have the same structure, just slightly different primary keys. I want to create a query that will list all the data from table one, then under it, list all the info from table two... Is this possibe? Thanks Rich
SELECT column_name(s) FROM table_name1 UNION ALL SELECT column_name(s) FROM table_name2 The column names you choose need to be the same from each table but you can use aliases e.g. SELECT fname as NAME, sname as SURNAME FROM names UNION ALL SELECT NAME, SURNAME FROM customers
