Re: update question

In article <3c7d1a39.16078802_at_news.dal.ca>, ttigger4321_at_hotmail.com says...
>
>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"
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:273215737113 for two different (ansi compliant) syntaxes that show you how to implement this SQLServer syntax in a way that all databases should be able to handle.

>oracle 8i on aix
>
>thanks
>cheers,
>tony
>494-1021 w
>461-4550 h

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp