求一简单ＳＱＬ
表Ａ
ＦＦ　　ＧＧ
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