Re: turn a select into an update (with multiple joins)

update flroutg set flworkc = 9155
where flworkc = 3155 and flprodno in (select bomparnt from bommstr join
ildpf on BOMCHILD = ILDINO where ILDDM1>= .25 and BOMDATEF< 20120305 and
BOMDATDS> 20120305 )


On Mon, Mar 5, 2012 at 10:59 AM, McGovern, Sean
<Sean.McGovern@xxxxxxxxxxxx>wrote:

Would this work for you ?

Create View QTEMP/MYVIEW as
select FLWORKC, FLPRODNO, BOMCHILD
from tfactlib/FLROUTG
join tfactalib/BOMMSTR on BOMPARNT = FLPRODNO join tfactlib/ildpf on
BOMCHILD = ILDINO where FLWORKC = 3155 and ILDDM1>= .25 and BOMDATEF<
20120305 and BOMDATDS> 20120305

Update QTEMP/MYVIEW Set FLWORKC = 9155



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: 05 March 2012 15:54
To: midrange-l@xxxxxxxxxxxx
Subject: turn a select into an update (with multiple joins)

The following SQL returns the list of records I want to update:

select FLWORKC, FLPRODNO, BOMCHILD
from tfactlib/FLROUTG
join tfactalib/BOMMSTR on BOMPARNT = FLPRODNO join tfactlib/ildpf on
BOMCHILD = ILDINO where FLWORKC = 3155 and ILDDM1>= .25 and BOMDATEF<
20120305 and BOMDATDS> 20120305


I want to "SET FLWORKC = 9155"