UPDATE BFDTA.F30026 A
SET IELITM =
(SELECT IBLITM
FROM BFDTA.F4102 B
WHERE A.IEITM = B.IBITM
AND A.IEMMCU = B.IBMCU
AND A.IELITM = ' '),
IEAITM =
(SELECT IBAITM
FROM BFDTA.F4102 B
WHERE A.IEITM = B.IBITM
AND A.IEMMCU = B.IBMCU
AND A.IEAITM = ' ')
WHERE A.IELITM = ' '
AND A.IEAITM = ' '
No comments:
Post a Comment