Exclude Results from another table

[benkingery]

I have a table that I want to query (I won't put the query in here since it is so complex). This table contains items and information about items. I have another table that has orders on the items in the first table. In my query of the item table, I would like to remove any items that might also be listed on the item order table.

What is the sql syntax for doing this?

 

[pbaldy]

Have you tried the unmatched query wizard? It sounds like what you want (it will use what is often called a frustrated join).

 

[benkingery]

Thanks for the reply. I have never heard of this option. I'll take a look at it.