SELECT A.CDJIGYO CDJIGYOT, B.NMJIGYO NMJIGYOT, SUM(A.MNQUARTER1) TOTAL1, SUM(A.MNQUARTER2) TOTAL2, SUM(A.MNQUARTER3) TOTAL3, SUM(A.MNQUARTER4) TOTAL4 FROM IPBMN.TKJ03T A LEFT OUTER JOIN IPBMN.TKM04T B ON (A.CDCO = B.CDCO AND A.YRBUD = B.YRBUD AND A.CDJIGYO = B.CDJIGYO) WHERE A.YRBUD = 1999 AND A.CDSC = '0001' AND A.KILOAD = '0' GROUP BY A.CDJIGYO, B.NMJIGYO ORDER BY A.CDJIGYO
报ORDER BY A.CDJIGYO 错,不知道是什么原因,请大家帮忙.
SELECT A.CDJIGYO CDJIGYOT, B.NMJIGYO NMJIGYOT, SUM(A.MNQUARTER1) TOTAL1, SUM(A.MNQUARTER2) TOTAL2, SUM(A.MNQUARTER3) TOTAL3, SUM(A.MNQUARTER4) TOTAL4 FROM IPBMN.TKJ03T A LEFT OUTER JOIN IPBMN.TKM04T B ON (A.CDCO = B.CDCO AND A.YRBUD = B.YRBUD AND A.CDJIGYO = B.CDJIGYO) WHERE A.YRBUD = 1999 AND A.CDSC = '0001' AND A.KILOAD = '0' GROUP BY A.CDJIGYO, B.NMJIGYO
)ORDER BY CDJIGYOT