delete from (
select * from mydatabase.dbo.test1,mydatabase.dbo.test2
where
mydatabase.dbo.test1.ID=mydatabase.dbo.test2.ID and
mydatabase.dbo.test1.ID=1
)
这个不对吗?
怎样改??不要用VIEW
...全文
18811打赏收藏
delete 语句的简单问题,请指教!!
delete from ( select * from mydatabase.dbo.test1,mydatabase.dbo.test2 where mydatabase.dbo.test1.ID=mydatabase.dbo.test2.ID and mydatabase.dbo.test1.ID=1 ) 这个不对吗? 怎样改??不要用VIEW
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
)