求一简单ＳＱＬ
表Ａ
ＦＦ　　ＧＧ
5555         1233
5454         2345
1233         2222
2345
2222
我想查出　ＦＦ　里　ＧＧ里没有的数据．

------解决方案--------------------
select * from a where ff not in (select gg from a)
------解决方案--------------------

create table 表A(FF varchar(100),GG varchar(100))

insert into 表A
select 5555, 1233 union all
select 5454, 2345 union all
select 1233, 2222 union all
select 2345,null union all
select 2222,null

select * from 表A

select * from 表A
where isnull(FF, ' ') not in (select isnull(GG, ' ') from 表A)


drop table 表A