Sub query Vs. Join

Can anyone pl verify the following two queries and say whether both of them are same... 1. select DISTINCT a.* from t_aps_grp a, t_aps_usr b, t_bat_ent_log c, t_batch d, t_aps_batch_item e, t_applacct f where a.grp_id = b.grp_id and b.login_id = c.login_id and c.batch_id = d.batch_id and d.batch_id = e.batch_id and e.applacct_id = f.applacct_id and f.applacct_id > 2000 ; 2. select * from t_aps_grp where grp_id in (select grp_id from t_aps_usr where login_id in (select login_id from t_bat_ent_log where batch_id in (select batch_id from t_batch where batch_id in (select batch_id from t_aps_batch_item where applacct_id in (select applacct_id from t_applacct where applacct_id > 2000))))); If I remove the DISTINCT from the first query, it returns more rows than the second.( I think it b'cos of cartesian product in case of join). Which one is faster?????? Thanks krishnakumar Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.