RE: Doubt in SQL

Did you see my reply?

Update a
Set (a2,a3) = (select b2,b3
               from b
               where a1 = b1)


Note: You need to make sure the select returns only one row.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Stiju Easo
Sent: Tuesday, August 01, 2006 8:10 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Doubt in SQL

Wont the select return multiple rows?
  It was my doubt from begining.


On 7/28/06, Reggie Acosta - El Monte <racosta@xxxxxxxxxxxxxxx> wrote:

This is untested.

update devmrr/cmsslsf
   set slsgrpnum = (select pvsgrpnum
                      from devmrr/cmspvsf
                     where slspaxnum = pvspaxnum ),
      slssgrpnum = (select pvssgrpnum
                      from devmrr/cmspvsf
                     where slspaxnum = pvspaxnum )

HTH,
Reggie Acosta



--
This is the RPG programming on the AS400 / iSeries 

(RPG400-L) mailing list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) 
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.