select * from table1 where the entry is not in table2

[Access9001]

How do I do this?

 

[Brianwarnock]

Look at the unmatched query wizard

 

[scalextric59]

Select * from <table1> where <table1>.<code> not in (select <table2>.<code> from <table2>)