delete from T_Table1 where ID in(select B.SALEMODULEID
from T_Table2 A
JOIN T_Table3 B ON A.ID1 = B.ID2
JOIN T_Table4 C ON C.ID3 = B.ID2
WHERE A.Style = 1 AND ID4 = '123') and ID5= '321'
SQL server删除一个表中多条数据
最新推荐文章于 2024-01-26 09:55:00 发布