Question

sql中为什么总是提示with附近有语法错误？

with [view2]([callnumber],[sum]) as
(select [callnumber],sum(qty)
from [purchase_order4],[ordered4]
where [purchase_order4].[ponum] = [ordered4].[ponum]
group by [callnumber])
select [A].[name],[A].[ISBN],[A].[callnumber]
from [title4] as A,[view2] as C
where [A].[callnumber] = [C].[callnumber] and
[C].[sum]>10 and
[A].[callnumber] in (select [callnumber],count(supplier_id)
from [ordered4]
group by [callnumber]
having count(supplier_id)>1)

Answer 1

with 是 CTE 的语法。
SQL Server 2005 以上版本 （含 SQL 2005） 支持。

SQL 2000 与以下的版本， 是不支持的。