Interview Question on Subqueries vs Regular joins

Hi!

I was asked the following question at a technical interview: when would you use subqueries and when would you use regular joins (pros and cons of each approach in terms of design and performance)?

I have read several articles on the subject but could not find a good answer to this question.

Any help would be appreciated.

Thanks! Received on Mon Feb 11 2008 - 10:44:52 CST