O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

OUTER JOINs

An OUTER JOIN operation returns all rows that match the JOIN condition, and it may also return some of the rows that don't match, depending on the type of OUTER JOIN used. There are three types of OUTER JOIN: RIGHT OUTER JOIN, LEFT OUTER JOIN, and FULL OUTER JOIN.

In INNER JOIN, the order of the tables in the query doesn't matter, whereas in OUTER JOIN, the order of the tables in the query is important.

Tip

A LEFT OUTER JOIN can be translated into a RIGHT OUTER JOIN, and vice versa if you change the order of the tables in the join.

An OUTER JOIN can be seen as the result of the union of an INNER JOIN and all unmatched rows in

  • The left table in the case of LEFT OUTER JOIN

  • The right table in the case of RIGHT OUTER JOIN

  • Or both in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required