* 밑에가 소스인데,... 저 그림의 빨간 부분만 소계로 나오게 하고 싶은데.. 어떻게 해야 나올수 있을까..ㅠㅅㅠ




SELECT IG.ITEMGRP_CD AS 품목군코드,

       IG.ITEMGRP_NM AS 품목군명,

  I.ITEM_CD AS 품목코드,

  I.ITEM_NM AS 상품명,

  I.ITEM_DC AS 규격,

  TG.TRGRP_CD AS 거래처군코드,

  TG.TRGRP_NM AS 거래처군명,

  T.TR_CD AS 거래처코드,

  T.TR_NM AS 거래처명,

  SUM(LD.CLS_QT) AS 수량,

  SUM(LD.CLS_UM) AS 단가,

  SUM(LD.CLSG_AM) AS 금액


FROM LSALECLS LH

JOIN LSALECLS_D LD ON LD.CO_CD=LH.CO_CD AND LD.CLS_NB=LH.CLS_NB

JOIN STRADE T ON T.CO_CD=LH.CO_CD AND T.TR_CD=LH.TR_CD

JOIN STRADEGRP TG ON TG.CO_CD=LH.CO_CD AND TG.TRGRP_CD=T.TRGRP_CD

JOIN SITEM I ON I.CO_CD=LH.CO_CD AND I.ITEM_CD=LD.ITEM_CD

JOIN SITEMGRP IG ON IG.CO_CD=LH.CO_CD AND IG.ITEMGRP_CD=I.ITEMGRP_CD


WHERE LH.CO_CD='3005' AND LH.CLS_DT>='20140501'AND LH.CLS_DT<='20140531' 

GROUP BY IG.ITEMGRP_CD,IG.ITEMGRP_NM,I.ITEM_CD,I.ITEM_NM,TG.TRGRP_CD, TG.TRGRP_NM,I.ITEM_DC,T.TR_CD,T.TR_NM