RE: SQL UPDATE AND JOIN

This is the winner... thanks guys!
 
 
 
 
 
Thanks,
 
 
Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929


-----Original Message-----
From: "Erhardt, Bill" <Bill.Erhardt@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Date: Tue, 9 Jan 2007 11:06:42 -0500
Subject: RE: SQL UPDATE AND JOIN


How about
Update instrmst
Set Firsta = 'A'
Where RiRINS in(Select FIINST from Reptinst) 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jay Vaughn
Sent: Tuesday, January 09, 2007 10:52 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL UPDATE AND JOIN

I want to update INSTRMST file where the field matches the field in the
REPTINST file... the syntax checker does not like the following... What
is the correct structure?


 UPDATE INSTRMST (SELECT FROM INSTRMST JOIN REPTINST ON RIRINS = FIINST)
SET 
FIRSTA = 'A'       
 
 
 
 
Thanks,
 
 
Jay Vaughn
iSeries Senior Programmer/Analyst
RateWatch
jayv@xxxxxxxxxxxxxx
251-633-8929
--
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.