这样的SQL如何写

select   a.areacode   as   areacode,a.areaName   as   AreaName,  
    sub_book_num=(select   isNull(sum(b.book_num),0)   from   cw_book_bill   b    
                where   b.areacode=*a.areacode   and   b.Cz_Date='''+   E_Date   +'''),  
    retail_book_num=(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=(sub_Book_Num-retail_Book_num)     --此处报错，如何修改呢？  
    from   syspz_areacode   a   order   by   a.areacode  
                         
                        想求出SUB_BOOK_NUM和RETAIL_BOOK_NUM的差值  
   
    数据库是SQL   SERVER 问题点数：10、回复次数：3Top

1 楼haishen（海神）回复于 2002-04-01 10:33:45 得分 3

缺空格吧！Top

2 楼windindance（风舞轻扬·白首为功名）回复于 2002-04-01 10:41:40 得分 3

不能够对这种字段直接运算的，必须：  
  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+'''),Top

3 楼windindance（风舞轻扬·白首为功名）回复于 2002-04-01 10:42:21 得分 4

其实最好sum_book   是在程序中通过计算字段来处理。Top

相关问题

• date
• areacode
• book
• retail
• sum
• num
• bill
• select isnull
• sub
• from cw

• 帖主：lovefox_zoe
• haishen
• windindance
• windindance

• Delphi类图书
• Delphi类源码下载
• Delphi控件下载