个人统计

SELECT     NVL(T2.TEMP_COUNT, 0) tldp,
  FROM RYMC_VIEW T1
  LEFT JOIN (SELECT COUNT(TT.ID) TEMP_COUNT, TT.ID
               FROM ZHUSU_VIEW TT
              GROUP BY ID) T2
    ON T1.ID = T2.ID