不能够对这种字段直接运算的,必须:
sum_book = select isNull(sum(b.book_num),0) from cw_book_bill b
where b.areacode=*a.areacode and b.Cz_Date='''+ E_Date +'''),
-
(select isNull(sum(c.book_num),0) from cw_retail_bill c
where c.areacode=*a.areacode and c.Pub_date='''+E_date+'''),
sum_book = select isNull(sum(b.book_num),0) from cw_book_bill b
where b.areacode=*a.areacode and b.Cz_Date='''+ E_Date +'''),
-
(select isNull(sum(c.book_num),0) from cw_retail_bill c
where c.areacode=*a.areacode and c.Pub_date='''+E_date+'''),
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货