merging table records

[richie]

Hi,

I have two identical tables table1,table2

table1 contains 5848 records
table2 contains 2234 records

How do I write a query to return the total records in both tables, which would be 8082 records?

Both tables have primary key called id.

TIA,
Richie.

[Drakla]

select from table1 union select from table2;

[edit] Oh, should just add that this will automatically merge duplicate records, if you don't want that you say UNION ALL, like

select from table1 union all select from table2;

And if you want to use an order by you have to put the select queries in brackets like

(select from table1) union (select from table2) order by foo;