小编在公司遇到一个问题,就是怎么怎样用一个sql语句,实现多个表求多个count
直接上实例
关键:union all
SELECT COUNT(*) FROM tj_active_person WHERE researcher_id='35' AND is_delete=0
UNION ALL
SELECT COUNT(*) FROM tj_active_person WHERE researcher_id='35' AND sign_status=1 AND is_delete =0
UNION ALL
SELECT COUNT(*) FROM tj_report where researcher_id='35' AND is_delete=0
UNION ALL
SELECT COUNT(*) FROM tj_registration where invitation_code IN(SELECT inviter_code FROM tj_registration WHERE id='35' AND is_delete=0)
不得不感叹,mysql数据库的强大和简洁.