Access is hanging due to this querry.any one guide me

[aniletc37]

Hi,
I have two tables each tables have one column(id).Im writing sql to get the data from table2
where table 2 ids are not present in table1.bY using the below queery.These tables have huge data.Whnever i write the below
code access is hanging.
Please help me on this
select id from table2


where id not in(select id from table1)

[orange]

Try

select table2.id from
table2 left join table1 on
table2.id = table1.id
where
table1.id is null;

[aniletc37]

Thx.Its working fine