pfd
Reputable Poster
Would someone please help me with this SQL query?
I am trying to update the lead-time field in F4102 with the value that is in the URAB field in F55PRICE. I am joining F4102 and F55PRICE by LITM and MCU.
The statement below returns a message that “Result of Select more than one row”.
Update dvindta/f4102
Set ibltlv= (select prurab from dvindta/f55price inner join dvindta/f4102 on prmcu = ibmcu and prlitm=iblitm)
Where
Exists (select prurab from dvindta/f55price inner join dvindta/f4102 on prlitm = iblitm and prmcu = ibmcu)
Thanks,
Matt
One World Xe, SP23,Update 7, AS/400 v5r3
I am trying to update the lead-time field in F4102 with the value that is in the URAB field in F55PRICE. I am joining F4102 and F55PRICE by LITM and MCU.
The statement below returns a message that “Result of Select more than one row”.
Update dvindta/f4102
Set ibltlv= (select prurab from dvindta/f55price inner join dvindta/f4102 on prmcu = ibmcu and prlitm=iblitm)
Where
Exists (select prurab from dvindta/f55price inner join dvindta/f4102 on prlitm = iblitm and prmcu = ibmcu)
Thanks,
Matt
One World Xe, SP23,Update 7, AS/400 v5r3