Query Help
From: Rob Edwards <raedwa01_at_hotmail.com>
Date: 5 Apr 2002 13:55:17 -0800
Message-ID: <8ea2ecb0.0204051355.7408f286_at_posting.google.com>
Date: 5 Apr 2002 13:55:17 -0800
Message-ID: <8ea2ecb0.0204051355.7408f286_at_posting.google.com>
I have two tables that have a foreign key relationship.
I want to get a query that will give me all the records that are in one table, or the other, but not both.
For example
Table 1 has the following records
Item1
Item2
Item4
Table 2 has:
Item1
Item3
Item4
The result from the query should be:
Table1Items Table2Items
Item2 NULL NULL Item3
I can get a query that returns Table1's items or table2's but not both on one result set Received on Fri Apr 05 2002 - 23:55:17 CEST