Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Join or not ?

Join or not ?

From: Etienne Massip <moutonnoir_at_netcourrier.com>
Date: 6 Mar 2002 12:01:26 -0800
Message-ID: <f033dea7.0203061201.bc2d086@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 - 14:01:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US