Query quandry

G

gail

Is there anyone who can explain how to query 2 separate
tables for matching AND unmatching data? I have to compare
2 tables looking for matched and unmatched values in 2
different columns.
 
E

es

Use the wizzard to help you create this. It will only
allow you to choose one field to compare but as the
wizzard ends there is a check box for if you want to
modifiy the query. Check this then you can duplicate the
code for the other field to compare.
 
Top