请教啊，查询A表中未曾出现在B表和C表中的记录,sql2000

[sdmc01]

请用sql2000,另外数据记录有5万条以上，请尽量效率高，谢谢
A表

id   
001 
002
003
004
005
006 

B表

002
003
005

C表

003
004
005

查询结果
001
006

[ws_hgo]

select * from A
where not exists
(
  select * from B where A.id = id
)
and
not exists
(
  select * from C where A.id = id
)

[筱筱澄]

--1
select * from a
where not exists(select 1 from b where b.id=a.id)
and not exists(select 1 from c where c.id=a.id)

[孤独加百列]

SELECT * FROM A
WHERE NOT EXISTS 
(
SELECT 1 FROM (
SELECT * FROM B
UNION
SELECT * FROM C) AS D WHERE A.id = D.id 
)

[xiaosa_21]

declare @t1 table (id int)
insert into @t1
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6

--> 测试数据: @t2
declare @t2 table (id int)
insert into @t2
select 1


--> 测试数据: @t3
declare @t3 table (id int)
insert into @t3
select 3

select * from @t1
except
(select * from @t2
union
select * from @t3)

[sdmc01]

谢谢各位的帮忙