SQL Joins as Seen on a Diagram

Tweet

Jeff Atwood, the author of the Coding Horror blog, has a nice visual explanation of SQL joins. For the non-visual explanation, I refer you to the following articles:

• Inner joins
• Outer joins
• Cross joins
• Self joins
• Equi and non-equijoins
• Anti-joins and semi-joins

However, ANSI SQL join syntax does not always work in Oracle, at least up to version 10gR2.

Related articles:

• Back to basics: cross joins
• Back to basics: anti-joins and semi-joins
• Back to basics: outer joins

Filed in Joins, Oracle on 12 Oct 07 | Tags: concepts, join

---