Along with the reply other friends provided I would like to add one more.
As they mentioned it depends, we cant say one is better than other, but when you go for a sub query, you are limiting the query optimizer to use only Nested Loop join, but if you go with Join , the optimizer has options among Nested Loop, Merge and Hash joins so that it can choose one for the best plan
Friends I'm I correct ?
Thanks & Regards,
MC