finding rows in one table not in another
От
Brook Milligan
Тема
finding rows in one table not in another
Дата
Msg-id
199806122039.OAA29466@trillium.nmsu.edu
Список
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
В списке pgsql-sql по дате отправления