From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

LEFT vs. INNER vs. RIGHT JOIN

LEFT vs. INNER vs. RIGHT JOIN - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

LEFT vs. INNER vs. RIGHT JOIN

“

- [Instructor] Okay, now that we've talked about LEFT INNER, and RIGHT JOIN, let's hold them up side by side and compare outputs so that you can really understand the little nuances between the joins. As you're getting up to speed, I would suggest going to the course materials, finding this slide and printing it out. I think this side-by-side comparison is the best way to understand what's happening with each of these. So, we've got two tables, the actor and the actor award table, and in each of the three queries, actor is on the left, and actor award is on the right. The only difference between the three queries is the type of join. We have LEFT, INNER and RIGHT. Let's take a look at what happens to the results with each of the types of queries. When we use LEFT JOIN, it returns all values from the left table and then brings in any values from the right table where there's a match. It returns null for the right table where no match is found. So, take a look down here. What we see is…

Contents