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 개수 구하는 방법좀 알려주세요 @.@;
|