--创建临时表
SELECT (select count(*) from ssss_ccbs_ac_water_meter cm where cm.ssss_sso_case_no=c.ssss_codcaseId)ssss_no_of_ccbs_ac, c.ssss_codcaseId
into ssss_codcase_temp_0524 FROM ssss_codcase c
--删除临时表
drop table ssss_codcase_temp_0524
原文：https://www.cnblogs.com/shanshuiYiCheng/p/14883388.html