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>


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

Original text of this message