need a query to display all records in one table except items in a second table 1

[irethedo]

I have two tables and I want to display all the records that are in Ord_tbl who's System field does not
match the PartsDesc field in my IOM_tbl but am not able to get the query set up correctly.

Here is what my query looks like but it is displaying all records in the Ord_tbl:

SELECT Ord_tbl.Date, Ord_tbl.Cust_Name, Ord_tbl.System
FROM Ord_tbl LEFT JOIN IOM_tbl ON Ord_tbl.[System] = IOM_tbl.[PartDesc];

What am I missing?

Thanks

 

[MajP]

SELECT Ord_tbl.Date, Ord_tbl.Cust_Name, Ord_tbl.System
FROM Ord_tbl LEFT JOIN IOM_tbl ON Ord_tbl.[System] = IOM_tbl.[PartDesc]
WHERE IOM_tbl.[PartDesc] is null

 

[irethedo]

Thanks MajP !

 

[MajP]

However there are several ways to do this, and they are slightly different in how they work. You may want to become familiar with these:

https://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/