在sql server中能執行的語句在delphi中不能執行

[Alex_MrChen]

WITH AAA AS (
SELECT SUBSTRING(F41,1,4) AS YEA_ID,SUBSTRING(F41,6,2) AS MON_ID
,ISNULL(COUNT(PROJ_ID),0) AS PROJ_COUNT
,ISNULL(SUM(ISNULL(F13,0)),0) AS PROJ_PRICE
FROM BMS_V_JSW_FE_BASIC_DATA
WHERE F41 <> ''
GROUP BY SUBSTRING(F41,1,4),SUBSTRING(F41,6,2)
)
SELECT * FROM AAA


這句話在DELPHI中不能執行,錯誤信息:"INCORRECT SYNTAX NEAR THE KEYWORD 'WITH'"

[bdmh]

with前加分号

[Alex_MrChen]

[Quote=引用 1 楼 的回复:]
with前加分号
[/Quote]
感謝