select a.* from tbl1 a
left join tbl2 b
on a.key = b.key
where b.key is null
select A.* from TABL1 A
where not EXISTS(select 1 from TABL2 WHERE TABL2.[KEY]=TABL1.[KEY])
select a.* from tbl1 a
left join tbl2 b
on a.key = b.key
where b.key is null
还有一个问题
a.key = b.key 还是 b.key = a.key他们的区别是什么?
------------------------------------------------------------------------
没有区别,一样的,看着规范些.具体以哪个表为主进行的连接是由left/right join来指定的.
select A.* from TABL1 A
where not EXISTS(select 1 from TABL2 WHERE TABL2.[KEY]=TABL1.[KEY])
select A.* from tbl1 A,tbl2 where A.key > key or A.key < key
select a.* from tbl1 a
left join tbl2 b
on a.key = b.key
where b.key is null
会比
select A.* from TABL1 A
where not EXISTS(select 1 from TABL2 WHERE TABL2.[KEY]=TABL1.[KEY])