Hi,
I am new to Access. Can someone please me with following query.
It compares data from two tables and deletes entry from table 1 for entries in table 2.
I have two tables with one field each.
Sample data-
Table 1:Field1-
A
B
C
B
Table 2:Field1-
B
Expected Query Result
A
C
B
Thanks in advance for help.
Tushar