SELECT T2.DOCENTRY,T2.ITEMCODE,T4.ITEMNAME,T2.PLANNEDQTY,T0.PRICE*T0.QUANTITY AS'합계'
FROM IGN1 T0
INNER JOIN OIGN T1 ON T0.DOCENTRY=T1.DOCENTRY
LEFT JOIN OWOR T2 ON T0.BASEREF=T2.DOCENTRY
LEFT JOIN OCRD T3 ON T2.CARDCODE=T3.CARDCODE
LEFT JOIN OITM T4 ON T2.ITEMCODE=T4.ITEMCODE
WHERE T2.STATUS='L' AND T2.CLOSEDATE>='[%1]' AND T2.CLOSEDATE<='[%2]'
GROUP BY T2.DOCENTRY,T2.ITEMCODE,T4.ITEMNAME,T2.PLANNEDQTY,T0.QUANTITY,T0.PRICE,T2.CLOSEDATE
ORDER BY T2.CLOSEDATE,T2.DOCENTRY
기초가 없으니 어렵네요..
MSSQL 을 사용중인데, 위와같은 같은 번호를 가진 데이터의 합계를 구하고싶습니다..
SUM을 이용했는데도 저렇게 결과가 나오네요...뭐가 문제인지...
수정이라던지 뭔가 답이 안나와서 질문드려요..ㅜㅜ
Comment 1
-
Hisory
2014.06.23 10:17
이러시면 될듯하네여.
쿼리의 기초책도 한권사서 보실것을 추천해드립니다.
http://www.yes24.com/24/goods/11007169?scode=032&OzSrank=1
SELECT T2.DOCENTRY,T2.ITEMCODE,T4.ITEMNAME,Sum(T2.PLANNEDQTY),Sum(T0.PRICE*T0.QUANTITY) AS'합계'
FROM IGN1 T0
INNER JOIN OIGN T1 ON T0.DOCENTRY=T1.DOCENTRY
LEFT JOIN OWOR T2 ON T0.BASEREF=T2.DOCENTRY
LEFT JOIN OCRD T3 ON T2.CARDCODE=T3.CARDCODE
LEFT JOIN OITM T4 ON T2.ITEMCODE=T4.ITEMCODE
WHERE T2.STATUS='L' AND T2.CLOSEDATE>='[%1]' AND T2.CLOSEDATE<='[%2]'
GROUP BY T2.DOCENTRY,T2.ITEMCODE,T4.ITEMNAME
ORDER BY T2.DOCENTRY