Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ???? SQL question ????
SELECT *
FROM t1
WHERE (id1, id2, id3) NOT IN (SELECT DISTINCT Table1 id1, Table1 id2,
Table1 id3 FROM t2);
or better:
SELECT *
FROM t1
WHERE NOT EXISTS
(SELECT NULL FROM t2 WHERE t1.id1 = t2.Table1 id1 AND t1.id2 = t2.Tab
le1 id2
AND t1.id3 = t2.Table1 id3);
/J rn
ilepper wrote:
> Ok here's a nice SQL problem, who can solve this one?
>
> I have got 2 tables
>
> Table 1 :
> prim. key : Id1, Id2, Id3
>
> Table 2 :
> prim. key : Id
> for. key : Table1 id1, Table1 id2, Table1 id3
>
> I want to do the following : I would like all records from table 1 wher
e
> there's no record for it in table 2.
>
> Usualy it would look something like this :
> select * from table 1 where id not in (select id from table 2)
> but now table one has more attributes forming the prim. key.
>
> How can it be done, anyone?
>
> Thanks anyway for trying,
> by the way, I am using Orcale version 7, and Delphi 3 to excute the SQL
> query.
>
> Ido de Lepper
> ilepper_at_fac.fbk.eur.nl
Received on Thu Jan 15 1998 - 00:00:00 CST