I need to find the set of rows in one table that are not in another
table. I used a query like the following:
select distinct id from mytable1 where id not in (select distinct id from mytable2);
However, this revealed no rows, even though I know of instances where
id from mytable1 is absent from id in mytable2. Is there some other
way to do this? Am I missing something? Is there a workaround?
Cheers,
Brook