SELECT ...생략  

FROM ( SELECT ***생략

            FROM merch_master m, tlf_point t 

            WHERE t.merch_no(+) = m.merch_no AND m.jehyu_cd != '810' AND m.jehyu_cd != '999' 

            GROUP BY m.jehyu_cd, m.merch_no, m.sangho, m.saup_no, m.merch_rank, m.ceo, m.regi_date, m.bl_cd 

            UNION ALL 

            SELECT ***생략

            FROM merch_master m, tlf_point_810 s 

            WHERE s.merch_no(+)= m.merch_no AND m.jehyu_cd = m.jehyu_cd AND m.jehyu_cd='810' 

            GROUP BY m.jehyu_cd, m.merch_no, m.sangho, m.saup_no, m.merch_rank, m.ceo, m.regi_date, m.bl_cd 

          ) g, jehyu_master a 

WHERE g.jehyu_cd = a.jehyu_cd AND not g.jehyu_cd = '999' AND g.regi_date between '00000000' and '20080116' 

GROUP BY g.jehyu_cd, a.jehyu_name, g.merch_no, g.sangho, g.saup_no, g.merch_rank, g.ceo, g.regi_date, g.bl_cd, g.save_amt, g.save_cnt, g.save_pnt, g.use_cnt, g.use_pnt, g.remain_pnt order by regi_date desc

 조인으로 해당값을 구했는데요 row 개수 구하는 방법좀 알려주세요 @.@;