Interview Question on Subqueries vs Regular joins

From: <>
Date: Mon, 11 Feb 2008 08:44:52 -0800 (PST)
Message-ID: <>


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

Original text of this message