update question

Hi. I wonder if there are any restrictions associated with the update command with respect to like named columns in tables involved in the update. For example

update table1 a
from table2 b
set col1 = b.col1
where a.col2 = b.col2
and a.col3 = b.col3

returns a "ORA-00971: missing SET keyword"

oracle 8i on aix

thanks
cheers,
tony
494-1021 w
461-4550 h Received on Wed Feb 27 2002 - 11:47:45 CST