What query do i use to get all products from 2 products tables

[bjsteyn]

Hey I have 2 Product tables which are the same in structure and I would like to get all the products from them. Which type of querie would I run.

The reason I have 2 Products tables is that the one Product table is Nestle products.The price lists for these products is based on a system Nestle uses that has a base, B&I,hospitality,wholesalers price based on the customers category.
The other Products table,which is other products the person i'm designing this for wants to sell, has only one price list which is independant of the customers category. In the orders form i want my combo box to inable the person using it to select any product of the two products tables.thanx bj

 

[pbaldy]

A UNION query:

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

 

[bjsteyn]

Thanx pbaldy,so simple but yet so difficult if u dont know