delete from mydatabase.dbo.test1 where mydatabase.dbo.test1.ID=1 delete delete from mydatabase.dbo.test2 where mydatabase.dbo.test2.ID not in (select mydatabase.dbo.test2.ID from mydatabase.dbo.test1.ID,mydatabase.dbo.test2 where mydatabase.dbo.test1.ID=mydatabase.dbo.test2.ID )
就是说不可以用一条delete语句删除两个表有关联的元组?
where mydatabase.dbo.test1.ID=1
delete delete from mydatabase.dbo.test2
where mydatabase.dbo.test2.ID not in
(select mydatabase.dbo.test2.ID from mydatabase.dbo.test1.ID,mydatabase.dbo.test2
where mydatabase.dbo.test1.ID=mydatabase.dbo.test2.ID
)