在sql server中能行的句在delphi中不能行
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'"

[解决办法]
with前加分号