Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update from a subquery
>> update X
>> set (A, B, C) = (
>> select D, min(E), min(F)
>> from Y
>> group by D
>> ) Y1
>> where X.A = Y1.D
> > > Did you try?
I think he did.
And got ORA-00933 error. (syntax error).
-- NoelReceived on Sat Aug 28 2004 - 07:45:20 CDT