mysql 相关子查询使用【主表得数据需要扩展（统计数据依赖与其他表，但是与主表有关联）】...

2019独角兽企业重金招聘Python工程师标准>>>

SELECT t.building,t.unit,t.room,t.ashcan 
,(SELECT COUNT(a.resident_id) from t_address_book a 
 where a.village_id = t.village_id AND a.building = t.building 
  and a.room = t.unit and a.house = t.room
  and a.`status` = 1
) AS regisNum
 from t_village_standard t 

where t.village_id = 317
and t.`status` = 1

转载于:https://my.oschina.net/kuchawyz/blog/3052341