--删除 Delete A from tab1 A Where Exists(Select * from tab2 Where id=tab1.id)
错了,改下 --删除 Delete from tab1 Where Exists(Select * from tab2 Where id=tab1.id)
现在想把tab1中id字段与tab2的id字段有重复的记录删去: 也即是把tab2表中ID 重复的去掉。语句: Delete From tab2 Where Exists (Select 1 From Tab1 Where ID = Tab1.ID) 想得到的是去除tab2所有记录的一个集合 :Select * from Tab1 Where Not Exists (Select 1 From Tab2 Where ID = Tab1.ID)
Delete From tab2 Where Exists (Select * From Tab1 Where id = Tab1.id) Select * from Tab1 Where Not Exists (Select * From Tab2 Where id = Tab1.id)
Delete A from tab1 A Where Exists(Select * from tab2 Where id=tab1.id)
--删除
Delete from tab1 Where Exists(Select * from tab2 Where id=tab1.id)
也即是把tab2表中ID 重复的去掉。语句:
Delete From tab2
Where Exists (Select 1 From Tab1 Where ID = Tab1.ID) 想得到的是去除tab2所有记录的一个集合 :Select * from Tab1
Where Not Exists (Select 1 From Tab2 Where ID = Tab1.ID)
Where Exists (Select * From Tab1 Where id = Tab1.id) Select * from Tab1
Where Not Exists (Select * From Tab2 Where id = Tab1.id)