Update with inner join - ORA-00971 missing SET keyword
861979May 11 2012 — edited May 12 2012Hi,
Update with inner join gives me ORA-00971 missing SET keyword. Please let me know if am I missing something here.
UPDATE Table_B INNER JOIN Table_A ON Table_B.colA = Table_A.colB SET Table_A.colC = ‘Invalid’
WHERE (((TableA.colD)=1) AND ((TableB.colG)=‘col_Value’) AND ((TableA.colC)=‘valid’));
Appreciate your time!