Search results

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...