<br /> SQL> desc t1<br /> Name Null? Type<br /> -------------------------------<br /> NO NOT NULL NUMBER(38)<br /> TID NUMBER(38)<br /> <br /> SQL> desc t2<br /> Name Null? Type<br /> ----------------------------------<br /> TID NOT NULL NUMBER(38)<br /> NM CHAR(10)<br /> NUM NUMBER(38)<br /> <br /> SQL> update t1,t2 <br /> 2 SET t2.num=220333<br /> 3 where t1.tid=t2.tid<br /> 4 and t1.no=1<br /> 5 ;<br />
UPDATE t2 SET t2.num = 220333 WHERE EXISTS( SELECT 1 FROM t1 WHERE t1.tid=t2.tid AND t1.no=1 )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)