Left and Right Joins

This lesson discusses 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

Level up your interview prep. Join Educative to access 70+ hands-on prep courses.