The mystery of Outer Joins

From my long time experience with Oracle, I noticed that a lot of people have problems with Outer Joins. Especially if the Outer Join also contains an additional restriction on the outer join table.

A few days ago I read a good article about that on Jeff’s blog – be warned, it’s a MS SQL Server blog ;-) – the article is called Criteria on Outer Tables and has good examples explaining the problem.

BTW, if you are new to the “new” ANSI style joins, check out Eddie Awad’s article series about the different ANSI style joins.

One thought on “The mystery of Outer Joins

  1. Thanks for the pointer. Looks like a good article.

    ANSI style joins are the only way to go. Once you get used to them they make the queries so much clearer.

Comments are closed.