SELECT oh.OAORNO as ORDER_NO,
CONVERT(DECIMAL(10,2),oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100)) as TOT_AMT,
oh.OARLDT as SEND_DATE,
oh.OAORDT as ORDER_DATE,
oh.OACUNO as CUS_NO,
cu.OKCFC1 as CUS_AREA
FROM MVXJDTA.OOHEAD AS oh 
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO 
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO 
WHERE (oh.OAORDT like('2016%') OR oh.OAORDT like ('2017%')) AND (oh.OAORTP IN ('041','911','941')) AND (((oh.OAORST between '22' and '66') ) and (oh.OAORSL not in('99'))) AND (ol.OBORST not in ('90','99')) 
AND (oh.OASMCD not in('11000','30001','30002','30003','30004')) 
GROUP BY oh.OAORNO,oh.OAORDT,oh.OACUNO,cu.OKSDST,cu.OKCFC1,oh.OANTLA,oh.OAOTDP,oh.OASMCD,oh.OAORST,oh.OARLDT
ORDER BY oh.OACUNO ASC<HR><font size='2'>Data prepare Complete . . . All Rows For Upload  -> [0]