mysql - 根据另一个表中的值删除一个表中的值

Question

我试图执行此语句以从 F30026 表中删除遵循列出的规则的记录。我可以使用该语句运行 select * from 和 select count(*) from ，但是在运行它时删除后它不喜欢它..它在将 F30026 定义为表 a 的“a”上丢失了

delete from CRPDTA.F30026 a
where exists (
select b.IMLITM from CRPDTA.F4101 b
where a.IELITM=b.IMLITM
and substring(b.IMGLPT,1,2) not in ('FG','IN','RM'));

谢谢!

Answer 1

这对我来说看起来像是一个内部联接，请参阅 MySQL - DELETE Syntax

delete a from CRPDTA.F30026 as a
inner join CRPDTA.F4101 as b on a.IELITM = b.IMLITM
where substring(b.IMGLPT, 1, 2) not in ('FG', 'IN', 'RM')

请注意别名语法 as a 和 as b。