Re: Interview Question on Subqueries vs Regular joins

leonard.reinstein_at_gmail.com wrote:
> 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.

Just out of curiosity, why was this cross-posted to clj.programmer? It's not a Java question.

-- 
Lew