Select items NOT not present

[KRegal]

I do most of my queries in design view, and I am unsure how to create this one (I believe it requires SQL). I would like to know all of the parts that are not on a given purchase order. I think the difference between a set containing all parts and a second set containing only parts on the purchase order is the correct way to approach this.



The only solution I can think to accomplish this is to select the two sets, then iterate through the parts on the purchase order and delete those parts from the full list.

Is there some sort of SQL operation that can perform this?

[KRegal]

Just one not.

[lfpm062010]

You are on the right track. If you can have a query that contains all the parts and a second query that contain the part on the purchase order. If you use all parts left join the part on purchase order and select the part of purchase order that is NULL then you will have the part that is not on the purchase order.

[KRegal]

Thank you! I will read into the different types of joins. Access' builder abstracts all of that away