Question

真对一个表的统计，但是sqlserver2008报关键字 'from' 附近有语法错误。

select a.org,a.baogao from (select produce_pjname as org,ISNULL((select sum(produce_amount) from T_produce b where Produce_type='报告' and b.Produce_pjname=a.Produce_pjname group by a.Produce_pjname),0)) as baogao from T_produce a group by Produce_pjname)

Answer 1

因为“TABLE”是SQL的关键字，所以会报错，只要在关键前后用[]就可以了 如: select * from [TABLE] 详细有那些是SQL的关键字，查查SQL帮助文档吧。 0蟆

Answer 2

修改

select a.org,a.baogao
from (select produce_pjname as org,ISNULL((select sum(produce_amount)
from T_produce b
where Produce_type='报告' and b.Produce_pjname=a.Produce_pjname
group by a.Produce_pjname),0) as baogao
from T_produce a group by Produce_pjname) t

追问

还是报错，哎

追答

看不到你的图