Re: Help :- testing if values are not in a table
From: Ed Bruce <edward_at_igate1.hac.com>
Date: 1996/04/01
Message-ID: <3160562E.257_at_igate1.hac.com>#1/1
Date: 1996/04/01
Message-ID: <3160562E.257_at_igate1.hac.com>#1/1
John Strange wrote:
>
> select id from main
> minus
> select id from temp
> /
>
I believe this will give him the id's in main that are not in temp. What he wanted was ids in temp that are not in main, which would be:
select id from temp
minus
select id from main;
Received on Mon Apr 01 1996 - 00:00:00 CEST