This seems like a simple question, but I just don't know the syntax. I have
two tables with ID numbers. The lists are almost the same, but there may be
a few ID's in one table and not the other. What is the query expression
syntax to get a list of the ID numbers that appear in only one of the tables?
Rick B - 31 Mar 2005 16:37 GMT
Go to the query tab.
Click New.
Select "Find Unmatched Query Wizard".
Rick B
> This seems like a simple question, but I just don't know the syntax. I have
> two tables with ID numbers. The lists are almost the same, but there may be
> a few ID's in one table and not the other. What is the query expression
> syntax to get a list of the ID numbers that appear in only one of the tables?