Find the odd one out - Urgent
Posted: Wed Jul 21, 2004 7:01 am
Hi all,
I have two database tables that should have the same number of values in them, but one has one value too many.
I need to find a query which can tell me which one is not in both tables.
Can anyone tell me how to do this?
The value which should match for both is category_id
Thanks
I have two database tables that should have the same number of values in them, but one has one value too many.
I need to find a query which can tell me which one is not in both tables.
Can anyone tell me how to do this?
The value which should match for both is category_id
Thanks