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.

• Next in forum: Internet Application Developer - Contract 6 months
• Prev in forum: Re: interesting problem
• Thread view: 2 TABLES, one SELECT

[Reply to this message]