RE: Doubt in SQL

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

HTH,


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: Thursday, July 27, 2006 1:16 AM
To: RPG programming on the AS400 / iSeries
Subject: Doubt in SQL

Hi friends,

 I have a dbt.

 I have 2 tables a and b with a1,a2,a3 and b1,b2,b3 columns

 As of now I have a1,b1,b2 and b3. a2 and a3 are zeros.

 Now I need to move the values of b2 and b3 to a2 and a3 when a1 = b1.
 How to write a query for that??


I used


update devmrr/cmsslsf, devmrr/cmspvsf set slsgrpnum = pvsgrpnum , sl

ssgrpnum = pvssgrpnum where slspaxnum = pvspaxnum

This is the error message I am getting

*Token , was not valid. Valid tokens: SET*
So can't i use two table names in update statement?
-- 
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.