Re: SQL Trick.

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

Been available for years in DB2 for LUW. Relatively recent (V5R3 or V5R4 
I think, don't recall offhand) change for the System i. Was she at RPG 
World? I did explain it there... ;-)


Alan Campin wrote:
> 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.                             
>
>
>