I have searched the archives and the docs - and I cannot seem to find or
adapt an answer to this particular problem, hopefully someone out there
either knows how or can say simply that it cannot be done.
I have two tables that have the exact same schema, orders and old_orders:
order_id
Hi Mike,
Just a guess. Is perhaps one of the 4 records you mention a NULL record
(meaning no entry) ?
Why I am asking is because in this case you may want to use INNER JOIN or even
LEFT JOIN which should return also the NULL entry (incomplete datarecords).
That would make it
Select count(*)
Nils:
Not exactly... :)
I know for sure that there are 4 matching records - when I do:
(Select count(*) from orders where member_id='2') union (select count(*)
from old_orders where member_id='2')
I get:
+--+
| count(*) |
+--+
|1 |
On 25-Jun-2003 Mike Morton wrote:
I have searched the archives and the docs - and I cannot seem to find or
adapt an answer to this particular problem, hopefully someone out there
either knows how or can say simply that it cannot be done.
I have two tables that have the exact same schema,
