Re: Join or not ?

From: Marc Blum <marc_at_marcblum.de>
Date: Sat, 09 Mar 2002 10:54:17 GMT
Message-ID: <3c89e99f.9941905@news.online.de>

To throw a further word in:

correlated subquery

On 6 Mar 2002 12:01:26 -0800, moutonnoir_at_netcourrier.com (Etienne Massip) wrote:

>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

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Mar 09 2002 - 04:54:17 CST