DownwithFescue
Member
Can someone help me out with this statement?
update testdta/f0101 a set a.abat1 = 'XV'
where (select * from testdta/f0101 as c left outer join
testdta/f0401 as b
on c.aban8 = b.a6an8 where c.abat1 = 'V' And b.a6AYPD = ' ' And
b.a6APPD = ' ')
update testdta/f0101 a set a.abat1 = 'XV'
where (select * from testdta/f0101 as c left outer join
testdta/f0401 as b
on c.aban8 = b.a6an8 where c.abat1 = 'V' And b.a6AYPD = ' ' And
b.a6APPD = ' ')