时间戳

首页 > 解决方案 > 删除 FROM Kunden_ansprechpartner as a left join Ansprechpartner as b on a.AnsPaID=b.AnsPaID where b.AnsPaID=400 and Kdnr = 10088

mysql - 删除 FROM Kunden_ansprechpartner as a left join Ansprechpartner as b on a.AnsPaID=b.AnsPaID where b.AnsPaID=400 and Kdnr = 10088

问题描述

Delete FROM 
Kunden_ansprechpartner as a left join Ansprechpartner as b on a.AnsPaID=b.AnsPaID 
where b.AnsPaID=400 and Kdnr = 10088

为什么这个 Sql-Statemnt 不起作用；

标签： mysqljoinsql-delete

解决方案

您需要删除as，因为它不是关键字。此外，您需要指定要从中删除的表的别名，例如：

DELETE a.* FROM 
Kunden_ansprechpartner a left join Ansprechpartner b ON a.AnsPaID=b.AnsPaID 
WHERE b.AnsPaID=400 AND Kdnr = 10088

推荐阅读