Which is better join or in?

[anandkl]

Instead of IN use EXISTS

select * from table1 where exists(select 'x' from table2 where
table1.col1=table2.col1);

regards
anandkl