On Tue, 20 Jul 2004, matthiasUNDERSCOREweiss_at_gmx.at wrote:
> Galen Boyer wrote:
>> Let me turn it around on you. How would you describe what the
>> update should look like?
>
> Hm, probably something like this:
>
>
> update foo
> set ( col_1, col_2 ) = ( select i.col_3, ck.col_5
> from foo i, bar ck
> where i.col_1 = ck.col_1
> and i.col_2 = ck.col_2
> );
>
>
> Has my version any disatvantage?
Using yours, I would have to implicitly trust that the outer foo
being updated is the same foo in the join because I wasn't
allowed to code that relationship anywhere. Oracle's syntax
makes that relationship explicit.
--
Galen Boyer
Received on Tue Jul 20 2004 - 08:42:11 CDT
