Query Help: records in table X but not in Y. 1

[AlexTekTip]

I have two tables (X and Y). They both have column ITEM.

Y.ITEM must exist in X.ITEM

X.ITEM does not need to exist in Y.ITEM

I need a query that will give me a list of

X.ITEM's not in Y.


Thank You.

 

[AlexTekTip]

nevermind...

select x.item
from table1 a
where item not in (select unique item from table2)

 

[PruSQLer]

Left outer join with NULL predicate in the Where clause will work too.

select x.item
From x left outer join y
on x.item = y.item
Where y.item is null