![]() |
#2
mywisdom882016-03-24 17:18
|
(select isnull(sum(kc_billbody.mony),0) from kc_billbody left join bd_cbs on kc_billbody.cbs=bd_cbs.cbsid where bd_cbs.cbsid='10094311')+
(select isnull(sum(fyb_indirect_c.amt_fc),0) from fyb_indirect_c left join bd_cbs on fyb_indirect_c.cbs=bd_cbs.cbsid where bd_cbs.cbsid='10094311')),0) as SJ
from ays_cost_d left join bd_cbs on ays_cost_d.cbs=bd_cbs.cbsid where bd_cbs.cbsid='10094311' group by ays_cost_d.cbs
求高手指导 如何把这个语句糅合成只需要一个定位条件,现在是有四个定位语句!!

