Re: Join or not ?

From: Mourad Zamoun <mzamoun_at_idquest.net>
Date: Wed, 6 Mar 2002 23:25:54 +0100
Message-ID: <a66513$rrg$1@neon.noos.net>

for me the join operation is here:

WHERE T2.C1=T1.C1 Mourad:)

"Etienne Massip" <moutonnoir_at_netcourrier.com> a écrit dans le message news: f033dea7.0203061201.bc2d086_at_posting.google.com...
> Hello,
>
> Could anyone say me if the following simple SQL query contains a join
> operation or not ?
>
> UPDATE T1 SET T1.C2=(SELECT T2.C2 FROM T2 WHERE T2.C1=T1.C1)
>
> IMHO the answer is no, but my colleagues disagree :)
>
> Thx a lot,
>
> Etienne Massip
Received on Wed Mar 06 2002 - 16:25:54 CST