SELECT l.MRTRNR,l.MRTRDT,RTRIM(l.MRITNO),
CONVERT(DECIMAL(10,0),l.MRRPQT),h.MGTWLO,it.MMITDS
FROM MVXJDTA.MGLINE AS l
INNER JOIN MVXJDTA.MGHEAD AS h ON l.MRTRNR = h.MGTRNR
INNER JOIN MVXJDTA.MITMAS AS it ON l.MRITNO = it.MMITNO 
WHERE ((h.MGTRDT in(00) and (MRITNO not like '10990%') and (h.MGTWLO between '' and '')))
and (l.MRTRSH in('99','29'))
order by h.MGTRDT,h.MGTWLO,l.MRTRNR,l.MRPONR