mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
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
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