SELECT
MVXJDTA.MGLINE.MRITNO AS itno,
SUM (MVXJDTA.MGLINE.MRRPQT) AS getqty,
MVXJDTA.MGHEAD.MGWHLO AS wh,
MVXJDTA.MGHEAD.MGREMK as Remark
FROM
MVXJDTA.MGHEAD
INNER JOIN MVXJDTA.MGLINE ON MVXJDTA.MGHEAD.MGTRNR = MVXJDTA.MGLINE.MRTRNR
WHERE
MVXJDTA.MGHEAD.MGTRTP = 'I16' AND
MVXJDTA.MGHEAD.MGTRDT LIKE '%' AND
MVXJDTA.MGHEAD.MGREMK = N'V16' AND
MVXJDTA.MGHEAD.MGWHLO in AND
MRTRSH = '99'
GROUP BY
MVXJDTA.MGLINE.MRITNO,
MVXJDTA.MGHEAD.MGWHLO,
MVXJDTA.MGHEAD.MGREMK
Warning: Cannot modify header information - headers already sent by (output started at E:\www\fplus_ShortBill_test\update_swap2.php:1) in E:\www\fplus_ShortBill_test\update_swap2.php on line 70