select sum( (select count(*) from t_organization_machinery where organization_id=tor.id) )from t_organization tor
sql主表查询,附带显示符合条件子表记录数量。
最新推荐文章于 2024-05-16 14:47:58 发布
select sum( (select count(*) from t_organization_machinery where organization_id=tor.id) )from t_organization tor