Merlin Moncure wrote:
> Andreas wrote:
>
>>Doesn't something like
>>
>>UPDATE t1 SET col1=cola, col2=colb
>> FROM t1 JOIN anothertable ot ON t1.id=ot.id
>> WHERE ...
>>
>>Work the way you'd like it? I'd expect this syntax to be as widely
>>portable and performant.
>
>
> Hmm, 'from' in an update is a PostgreSQL extension to the update command
> :).
Ooops... Oracle doesn't know it, I used to use it on MSSQL.
Regards,
Andreas