Re: ???? SQL question ????

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 CST