I have two tables in a database and I'm trying to find items in one table that does not have a match in another table... All of the fields don't match, but just a couple. Here's what I tried and it does return some records, however, as I spot check, it's returning records that do have a match.
from IronData B
where not exists (select * from ndxdata A where A.custbox <>''
and A.custbox in (B.custboxnbr, B.SKPboxnbr));
I'm looking for any record from table B which fields 'custboxnbr' or 'skpboxnbr' do not match a record from table A's 'custbox' field