Re: ???? SQL question ????
From: (wrong string) é Romano <jose.romano_at_astra.pt.astra.com>
Date: 1998/01/13
Message-ID: <01bd202d$c699d770$1f9711ac_at_pt-ast-p03240>#1/1
Date: 1998/01/13
Message-ID: <01bd202d$c699d770$1f9711ac_at_pt-ast-p03240>#1/1
Hi,
try this :
select * from table1 where id1||id2||id3 not in ( select id1||id2||id3 from table2)
JRomano
ilepper <ilepper_at_fac.fbk.eur.nl> wrote in article
<MPG.f254e6e8dd33d1198968d_at_nntp.eur.nl>...
> Ok here's a nice SQL problem, who can solve this one?
>
> I have got 2 tables
>
> Table 1 :
> prim. key : Id1, Id2, Id3
...
Received on Tue Jan 13 1998 - 00:00:00 CET