Conversion of Update from MSSQL generates "SQL command not properly ended"

Oracle 9i (9.0.2)

Using an update like the following:

update table1 set table1.col1 = table2.col1, table1.col2 = table2.col2 from table1,table2 where table1.recid = table2.recid and table2.recid in (1234,4567)

Generates the "SQL Command not properly ended" error.

What would be the proper way of doing this under Oracle 9 (the above is what we used under MS SQL)? All the solutions I have seen have been for 1 record returned or 1 record updating multiple records.

TIA Received on Fri Jul 23 2004 - 16:16:34 CDT