select * from TABLE_1
001AAA
002BBB
003CCC
004DDD
005EEE
select * from TABLE_2
001AAA
003CCC
005EEE
select * from TABLE_1
where not exists (select ID from TABLE_2 where TABLE_1.ID=ID and TABLE_1.Name=Name)
002BBB
004DDD
select * from TABLE_1
001AAA
002BBB
003CCC
004DDD
005EEE
select * from TABLE_2
001AAA
003CCC
005EEE
select * from TABLE_1
where not exists (select ID from TABLE_2 where TABLE_1.ID=ID and TABLE_1.Name=Name)
002BBB
004DDD
评论