Monday, January 23, 2012

Update LITM and AITM in F30026 from F4102


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