Skip to main content
  • EN

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?

I was not able to reproduce the issue. The NOT IN operator works fine, as well as the EXCEPT operator. See the attached demo: inlinequerier-except-vs-not-in.fmwt (FME 2017.1.2.1)

Reply


Community Stats

30,469
Posts
115,712
Replies
38,288
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.