Re: Update from a subquery

Try this:

    update X
    set (B, C) =
    (select min(E), min(F) from Y where x.a = y.d group by D)

The where clause should be part of the subquery. Received on Thu Aug 26 2004 - 13:24:21 CDT