Oracle ²éѯ½á¹ûÈçºÎÖظ´Ê¹Óã¿

select clusterno,
      clustername,
      description,
      (select count(*)
          from TBCLUSTERTOGRID t
        where t.clusterno = a.clusterno) as gridCount,
      (select count(*)
          from cell_0571 c,
              (select d.clusterno, SMSDRIW, smsdrie, smsdris, smsdrin
from rect500_hangzhour r, TBCLUSTERTOGRID d
where r.mi_name = d.rectsmid) t
        where (c.ilong > t.SMSDRIW and c.ilong < t.smsdrie)
          and (c.ilat > t.smsdris and c.ilat < t.smsdrin)
          and t.clusterno = a.clusterno) as BaseStation,
      (select count(*)
          from site_0571 s,
              (select d.clusterno, SMSDRIW, smsdrie, smsdris, smsdrin
from rect500_hangzhour r, TBCLUSTERTOGRID d
where r.mi_name = d.rectsmid) t
        where (s.ilong > t.SMSDRIW and s.ilong < t.smsdrie)
          and (s.ilat > t.smsdris and s.ilat < t.smsdrin)
          and t.clusterno = a.c