I want to use Inline Querier to find all rows in table CSV that are not in table DCDB. Lot_plan is the common column
this works (returns rows)
SELECT Lot_plan FROM CSV
EXCEPT
SELECT Lot_plan FROM DCDB
This does not work (returns zero rows)
SELECT * FROM CSV
WHERE Lot_plan NOT IN (SELECT Lot_plan FROM DCDB)
Why does the EXCEPT statement work and not the NOT IN statement?
