Posted by Ralf Sommer on 07/13/05 19:21

I have 2 tables TABLE1 , TABLE2 with same structure.
TABLE1 one has ID 1-100000
TABLE2 has ID 100001-200000

How can I SELECT over both tables.
Simple examples like:

select count(*) (from both tables) .......;
Result should be 200000.

select count(*) .....(from both tables) where ID> 90000
Result should be 110000;

I hope an easy one for you.

Thank you.

[Back to original message]