Selecting from two tables?

Question

I have two tables, orders and old_orders.

Each table has some similar fields and some different fields.

I want to select name and id from both tables and output all of the orders from both tables.

Thanks

Answer 1

I quess what you want is UNION, ie

SELECT name, id FROM orders WHERE ...
UNION
SELECT name, id FROM orders_old WHERE ...