Posted by Ed Murphy on 06/28/07 09:00

Chamnap wrote:

> I mean standard join by:
> Select * From Quiz, Question Where Quiz.id = Question.id

That's arguably not a join at all, though any reasonable database
server will optimize it into one under the covers. These days,
recommended practice is to do something like

select (list of columns)
from quiz x
join question y on x.id = y.id

For one thing, when you have a less trivial case than this example,
it makes it harder to leave out a join condition by mistake.

[Back to original message]