删除语句报错

[小野马1209]

;WITH cte as ( 
SELECT [往来对象代码],max([发生日期]) as '发生日期' FROM [dbo].['112202$']
WHERE [合计]<=0
GROUP BY [往来对象代码]
)

select * FROM [dbo].['112202$'] AS A WHERE EXISTS(
	SELECT 1 FROM cte AS B 
	WHERE
	A.[往来对象代码]=B.[往来对象代码]
	AND	A.[发生日期]>B.[发生日期])

删除语句报错

DELETE FROM [dbo].['112202$']  A WHERE EXISTS(
	SELECT 1 FROM cte AS B 
	WHERE
	A.[往来对象代码]=B.[往来对象代码]
	AND	A.[发生日期]>B.[发生日期])

/*消息 102，级别 15，状态 1，第 13 行
'A' 附近有语法错误。*/

[二月十六]

DELETE  FROM [dbo].['112202$']
WHERE   EXISTS ( SELECT 1
                 FROM   cte AS B
                 WHERE  [dbo].['112202$'].[往来对象代码] = B.[往来对象代码]
                        AND [dbo].['112202$'].[发生日期] > B.[发生日期] )

[卖水果的net]

DELETE A FROM [dbo].['112202$']  A  WHERE EXISTS(     SELECT 1 FROM cte AS B      WHERE     A.[往来对象代码]=B.[往来对象代码]     AND    A.[发生日期]>B.[发生日期])

[小野马1209]

引用 1 楼 sinat_28984567 的回复:

DELETE  FROM [dbo].['112202$']
WHERE   EXISTS ( SELECT 1
                 FROM   cte AS B
                 WHERE  [dbo].['112202$'].[往来对象代码] = B.[往来对象代码]
                        AND [dbo].['112202$'].[发生日期] > B.[发生日期] )

是不能用别名是吗

[二月十六]

引用 3 楼 kaijie_wu1209 的回复:

[quote=引用 1 楼 sinat_28984567 的回复:]

DELETE  FROM [dbo].['112202$']
WHERE   EXISTS ( SELECT 1
                 FROM   cte AS B
                 WHERE  [dbo].['112202$'].[往来对象代码] = B.[往来对象代码]
                        AND [dbo].['112202$'].[发生日期] > B.[发生日期] )

是不能用别名是吗[/quote] 可以用，用的话，用#2水版写的那个语句