1.in适合于子查询小,外部表大的情况
SELECT * FROM mreport_provider_input_total total WHERE EXISTS
(SELECT edu_school.corpid FROM mreport_provider_edu_school edu_school WHERE edu_school.corpid=total.corpid);
2.exists适合于子查询大外部表小的情况
SELECT * FROM mreport_provider_input_total total WHERE total.corpid IN
(SELECT edu_school.corpid FROM mreport_provider_edu_school edu_school WHERE edu_school.corpid=total.corpid);