Wednesday, March 14, 2012

Items Missing Primary Location in F41021


/* Formatted on 2012/03/14 06:31 (Formatter Plus v4.8.8) */
SELECT ib.ibmcu, COUNT (*)
  FROM testdta.f4102 ib
 WHERE NOT EXISTS (
          SELECT *
            FROM testdta.f41021 li
           WHERE ib.ibitm = li.liitm AND ib.ibmcu = li.limcu
                 AND li.lipbin = 'P')
                 group by ib.ibmcu

No comments:

Post a Comment