还有这个:
delete #SP_GL_BAL_T
from #SP_GL_BAL_T T left join MA_COA_ACC A on A.COA_CODE=
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)
AND A.ACC_CODE=T.CODE1
where A.IS_CURR<>'Y' OR A.IS_CURR is NULL OR A.IS_QTY<>'Y' OR A.IS_QTY is NULL
delete #SP_GL_BAL_T
from #SP_GL_BAL_T T left join MA_COA_ACC A on A.COA_CODE=
(select COA_CODE from MA_COMPANY where CO_CODE=@CO_CODE)
AND A.ACC_CODE=T.CODE1
where A.IS_CURR<>'Y' OR A.IS_CURR is NULL OR A.IS_QTY<>'Y' OR A.IS_QTY is NULL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货