SELECT MVXJDTA.MGLINE.MRITNO as itno, sum(MVXJDTA.MGLINE.MRRPQT) as getqty, MVXJDTA.MGHEAD.MGTWLO as wh FROM MVXJDTA.MGHEAD INNER JOIN MVXJDTA.MGLINE ON MVXJDTA.MGHEAD.MGTRNR = MVXJDTA.MGLINE.MRTRNR WHERE MVXJDTA.MGHEAD.MGRIDT LIKE '201806%' AND MVXJDTA.MGHEAD.MGTRTP IN ('T04', 'T05') AND MVXJDTA.MGHEAD.MGTWLO IN AND MVXJDTA.MGLINE.MRITNO NOT LIKE '600%' AND MROEND = '0' AND MRTRSH IN ('99','29') group by MVXJDTA.MGLINE.MRITNO,MVXJDTA.MGHEAD.MGTWLO