I'm wondering if anyone can help me develop the right sql query.
I'm trying to select a "customerNumber" in table 1, but only if it doesn't exist in table2.
I tried this
Select Table1.customerNumber From Table1, table2 Where table1.customerNumber NOT IN (select table2.customerNumber from table2)
It isn't right because it displays customerNumber that exist in table2.
Can someone please help me?