Query to exlcude certain row

[mrchonginhk]

I have 2 tables and there are one common field in 2 tables, say, product:-

Table A called ALL
Product/SalesAmt

TableB called EXCLUDE
Product/EndDate

If want a query to come up with a TableC called NET that contains
Table A except excluding the rows for Product that appear in Table B.
ie any Product appear in TableB, I want to exclude them from Table A and just to get remaining ones.

What is the SQL to get this ?

Preferred not to use action query. Thanks

 

[Norie]

Why not try using the Find Unmatched Query Wizard?

PS What made you think you might need an action query?

 

[mrchonginhk]

I once thought we need a delete query.
Find Unmatch wizard did the job. Good
h