总数
SELECT count(*) FROM gzw_pr.cw_pr_base_info
使用not in求数量
SELECT count(gzw_pr.cw_pr_base_info.ent_id) FROM gzw_pr.cw_pr_base_info WHERE ent_id not in (SELECT id FROM et_base_info);
使用left join
select count(a.ent_id) from gzw_pr.cw_pr_base_info a left join et_base_info b on a.ent_id=b.id where b.id is null;