delete tab_A
from tab_A
inner join tab_B
on tab_B.Id=tab_A.Id
where tab_B.ProjectNo = 'D19001' and tab_B.ConstructionUnit='湖南安装' and tab_B.WeldNo not like '%H%'
SQL 两表关联删除其中一张表数据
最新推荐文章于 2024-04-25 20:58:33 发布
delete tab_A
from tab_A
inner join tab_B
on tab_B.Id=tab_A.Id
where tab_B.ProjectNo = 'D19001' and tab_B.ConstructionUnit='湖南安装' and tab_B.WeldNo not like '%H%'