Re: update question

I would suggest that you start with a book on beginning SQL.

update table1 a
from table2 b

isn't going to get you very far.

Daniel Morgan

tony wrote:

> 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 - 13:13:54 CST