Left and Right Joins

Left & Right Joins

In this lesson we’ll look at left and right joins. The two joins add additional rows to the result set for one of the tables participating in the join. We can best exemplify the two joins pictorially as follows:

Left Join

Right Join

Syntax for Left Join

SELECT *

FROM table1

LEFT [OUTER] JOIN table2

ON <join condition>

Syntax for Right Join

SELECT *

FROM table1 ...