<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 t1,t2
*
ERROR at line 1:
ORA-00971: missing SET keyword
I want to update <num> column of t2 but using <no> column of table t1.