group by a.USER_NO
having sum(SHOULD_MONEY - isnull(FACT_MONEY,0)) >= 100000分组后用sum当条件
exists(select 1 from #DSSD_DEBT_USER
where DSSD_DEBT_USER.MIS_USER_CODE=#DSSD_DEBT_USER.MIS_USER_CODE)判断里面MIS_USER_CODE的等于外面的MIS_USER_CODE
having sum(SHOULD_MONEY - isnull(FACT_MONEY,0)) >= 100000分组后用sum当条件
exists(select 1 from #DSSD_DEBT_USER
where DSSD_DEBT_USER.MIS_USER_CODE=#DSSD_DEBT_USER.MIS_USER_CODE)判断里面MIS_USER_CODE的等于外面的MIS_USER_CODE
exists(select 1 from #DSSD_DEBT_USER
where DSSD_DEBT_USER.MIS_USER_CODE=#DSSD_DEBT_USER.MIS_USER_CODE)中select 1 from
#DSSD_DEBT_USER)会有什么样的显示结果.
的结果是当分组后的sum(SHOULD_MONEY - isnull(FACT_MONEY,0)) >= 100000
才能显示出来!
exists(select 1 from #DSSD_DEBT_USER
where DSSD_DEBT_USER.MIS_USER_CODE=#DSSD_DEBT_USER.MIS_USER_CODE)
可改成:
DSSD_DEBT_USER.MIS_USER_CODE IN(SELECT MIS_USER_CODE FROM #DSSD_DEBT_USER)
--