Can I do an EXCEPT or DIFFERENCE clause in Access?

[Air_Cooled_Nut]

Can MS Access perform the EXCEPT or DIFFERENCE clause? If so, what is the Access version of the syntax?

TIA!

 

[boblarson]

Haven't seen those before. Where are they from and how are they used?

 

[Air_Cooled_Nut]

Got it from a tome on SQL I have, "The Complete Reference SQL", ISBN 0-07-211845-8. I think I used it once or twice waaaaay back in college. Here's a search result I found that may help explain it (click on "Set Operations" in the TOC links):
http://hsqldb.org/doc/2.0/guide/ch07.html

It would be exactly what I want to do. I have a query that does an INNER JOIN with a data set and I want to do the same query but I now want to exclude that data set. This would be a fast and easy way to do it.

 

[boblarson]

Okay, what you do is to do an outer join on the exclusions (a query with what you want to exclude) and in the criteria put IS NULL for the key field in the query.

So, something like this:

SELECT TableA.PropertyFK AS PropertyID
FROM Table A LEFT JOIN queryB ON TableA.PropertyFK = queryB.PropertyFK
WHERE queryB.PropertyFK Is Null

 

[Air_Cooled_Nut]

Rats! I didn't want to do that but I guess I have to. Thanks