DELETE FROM sb_datapickup where PERIOD like '2025-04%' and wh in 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.MGTRDT LIKE '%' AND MVXJDTA.MGHEAD.MGTRTP IN ('T04', 'T05') AND MVXJDTA.MGHEAD.MGTWLO IN AND MVXJDTA.MGLINE.MRITNO NOT LIKE '600%' AND MROEND = '0' AND MRTRSH = '99' Group by MVXJDTA.MGLINE.MRITNO , MVXJDTA.MGHEAD.MGTWLO