sql-server - Sql - SQL 错误 [156] [S1000]：关键字“as”附近的语法不正确

Question

以下是我的查询 -

DELETE
FROM activity_details as ad, edit_details as ed
LEFT JOIN edit_details as ed
ON ed.details_id = ad.row_id
WHERE year(ad.activity_datetime)  = year(GETDATE())-10

我收到错误 SQL 错误 [156] [S1000]：关键字“as”附近的语法不正确。SQL 错误 [156] [S1000]：关键字“as”附近的语法不正确。

你能帮我改正语法吗

标签： sql-servermssql-jdbc

Answer 1

像下面这样改变它。如果您在删除语句中使用，则需要使用alias名称删除。FROM

DELETE ad
FROM activity_details as ad
LEFT JOIN edit_details as ed
ON ed.details_id = ad.row_id
WHERE year(ad.activity_datetime)  = year(GETDATE())-10