Exception Query Between Two Tables?

[BTilson]

I have two tables, Part and Vendor_Quote. Each table has a unique part identifier. I need to create a query that will show me records in Part that DO NOT have a corresponding record in Vendor_Quote.

I know this is doable, but my mind is drawing a blank. How would I go about setting up such a query?

Any help will be greatly appreciated.

Thanks!

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[AlexCuse]

You want a left join, with a null filter on the right side (ie you only want to show rows from left table without corresponding record on right table)

select Part.*
from Part 
left join 
Vendor_Quote
on Part.Unique_Part_Identifier = Vendor_Quote.Unique_Part_Identifier
where Vendor_Quote.Unique_Part_Identifier is null

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom