------------------------------------------------------------------------------

SELECT n.cust_id,
                  AF_GET_CUST_NAME(p_corp_id, n.cust_id) AS cust_name,
                  n.name_gubun,
                  sum(n.tbill_qty) AS tbill_qty,
                  sum(n.supp_amt) AS supp_amt
              FROM  (
                   SELECT a.cust_id,
                      c.name_gubun,
                       tbill_qty,
                      supp_amt
                    FROM  AT_STAX_BILL a,
                      AT_STBILL_ITEM b,
                      AV_CITEM_NAME c
                   WHERE a.corp_id   = p_corp_id
                   AND   a.sect_id   = p_sect_id
                   AND   a.tbill_yymm  BETWEEN p_fr_yymm AND p_to_yymm
                   AND   a.corp_id   = b.corp_id
                   AND   a.sect_id   = b.sect_id
                   AND   a.tbill_yymm = b.tbill_yymm
                   AND   a.tbill_no   = b.tbill_no
                   AND   b.tax_item   = c.item_id
                   UNION  ALL
                   SELECT distinct
                      a.cust_id,
                      c.name_gubun,
                      0 AS tbill_qty,
                      0 AS supp_amt
                   FROM  AT_STAX_BILL a,
                       AT_STBILL_ITEM b,
                       AV_CITEM_NAME c
                   WHERE  a.corp_id   = p_corp_id
                   AND   a.sect_id   = p_sect_id
                   AND   a.tbill_yymm  BETWEEN p_fr_yymm AND p_to_yymm
                   AND   a.corp_id   = b.corp_id
                   AND   a.sect_id   = b.sect_id
                   AND   a.tbill_yymm  = b.tbill_yymm
                   AND   a.tbill_no   = b.tbill_no
                  )n
              GROUP BY n.cust_id, n.name_gubun

--------------------------------------------------------------------------

비슷한 식의 Select문을 union all로해서 합쳐서 이 상위 질의에서 그룹을 시킵니다.

하는 이유는....값이 없는 Row에 대해서도 보여주기 위해서인걸로 아는데.

이방법 말고 다른 방법은 없을까해서 이렇게 글을 남겨봅니다

정답을 원한다기보다^^참고할수 있는 코멘트만으로도 전 만족합니다.

오늘 오후도 덥네요 다들^^시원한 하루 보내세요!