sql - 使用 WHERE 语句从不同表中删除行

Question

我需要根据两个表中的混合 where 语句从表中删除一些行。

我尝试过这个:

delete from tblI t1, tblS t2 
where t2.rcode = 'ALA' and t1.sid > 5

但我收到语法错误。请帮我解决这个问题

将其更改为 JOINS:

delete from tblI
inner join tblS
on tblI.sourceid = tblS.sourceid
where tblS.rcode = 'ALA' and tblI.sourceid > 5

但还是有问题，请帮忙。

Answer 1

您必须告诉它要从哪个表中删除。

delete t1
from tblI t1 
join tblS t2  on t1.sid = t2.sid
where t2.rcode = 'ALA' 
and  t1.sid > 5