在表A中查找表B中不存在的记录！！（如字段name）

[dgnApo]

该怎么写sql语句？
name是主键

[victorycyz]

select * from A left join B on A.name=B.name where B.name is null

[sunshareforever]

select * from a where a.name not in (select name from b )

[sunsunup]

select * from a where [name] not in (select [name] from b )

[pengdali]

select * from a where name not in (select name from b where name is not null)

[pengdali]

光用：
select * from a where [name] not in (select [name] from b )
如果b表的name有null值是会错的。

[dgnApo]

我要实现和in的概念相反的功能的sql语句，该怎么写？