Re: Update from a subquery

From: Noel <tomekb_XXXX__at_softman.pl>
Date: Thu, 26 Aug 2004 13:54:52 +0200
Message-ID: <cgkiud$3f$1@inews.gazeta.pl>

Dnia 2004/08/26 07:41, Użytkownik hedrew3 napisał:
> So, I try:
>
> update X
> set (A, B, C) = (
> select D, min(E), min(F)
> from Y
> group by D
> ) Y1
> where X.A = Y1.D

UPDATE X
    SET (B,C) =
    (

     SELECT MIN(E), MIN(F)
       FROM Y
      WHERE X.A = Y.D
      GROUP BY D

    );

--
Noel

Received on Thu Aug 26 2004 - 06:54:52 CDT