Query 2 tables to view UNCOMMON records.
Posted on 2004-09-07
I am trying to create a query that compares 2 tables and returns the records that are not common to both. I have tried every combination of INNER, OUTER joins, but can't seem to get it.
Table A records: record1, record2, record3, record4, record5
Table B records: none.
I insert into Table B: record 1, record2
I now want the query for Table A to showonly : record3, record4, record5
. . . excluding the 2 records that now exist in Table B
Tnaks in advance.