Is there any noticeable speed difference in these two queries? select * from table1, table2 where table1.field=table2.field blahblahblah select * from table1 where table1.field in (select field from table2) Both fields are indexed, of course. MShark
