求助,这个子查询是什么问题?

olive_fy

各位大哥看看下面的子查询有什么问题?为什么老是报错"无效的括号名称"select TabWIPFS.pn,sum(TabWIPFS.[q-ok"'??

谢谢了先!

SELECT WIPtotal.期初结存,RMtotal.领料小计
from
    ([select TabWIPFS.pn,sum(TabWIPFS.[q-ok]) as 期初结存
     from TabWIPFS
     group by  TabWIPFS.pn].as WIPTotal
   left join
     [select TabbaseFS.pn,sum(TabbaseFS.[q-ok]) as 领料小计
     from TabbaseFS
    where((TabbaseFS.pro)="领料")
     group by  TabbaseFS.pn].as RMTotal on WIPTotal.pn=RMTotal.pn)

tzh1600

sum(TabWIPFS.[q-ok]) as 期初结存

改成
sum([q-ok]) as 期初结存
应该可以吧

zyp

SELECT WIPtotal.期初结存,RMtotal.领料小计
from
    (select TabWIPFS.pn,sum(TabWIPFS.[q-ok]) as 期初结存
     from TabWIPFS
     group by  TabWIPFS.pn)  WIPTotal
   left join
     (select TabbaseFS.pn,sum(TabbaseFS.[q-ok]) as 领料小计
     from TabbaseFS
    where TabbaseFS.pro='领料'
     group by  TabbaseFS.pn) RMTotal
on WIPTotal.pn=RMTotal.pn

olive_fy

非常感谢!
按3楼的格式解决了问题!!
太谢谢了!

[ 本帖最后由 olive_fy 于 2009-1-8 19:12 编辑 ]