Re: SQL Trick.

[Alan Shore <AlanShore@xxxxxxxx>]

Alan
have a look at this web page.
http://www.itjungle.com/mgo/mgo121203-story02.html

and yes - I agree - SQL ALWAYS amazes me



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/21/2007 07:52:03 PM:

> We have a new programmer in our office and she created this query.
> The thing that blew my mind was the set using in effect a list. I
> thought you could only update a single field on a select but it works.
>
> Update PLNREQ a
>    Set (PPLANIB,
>         PITCLS) =
>           (Select b.PLANIB,
>                   b.ITCLS
>              From ITEMBL b
>              Where a.PITEM = b.ITNBR And
>                    a.PWH   = b.HOUSE)
>    Where a.PPLANIB = ' ' And
>          a.PITCLS = ' '
>
> The trick seems to be putting the brackets around the list of fields
> to update.
>
> Anybody seen this before? SQL never ceases to amaze me.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.