From the course: MySQL Data Analysis

Unlock this course with a free trial

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

LEFT JOIN

LEFT JOIN - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

LEFT JOIN

“

- [Instructor] Okay, now we're going to introduce our next type of JOIN, the LEFT JOIN. LEFT JOIN returns all records from your left table, the first table you name, and any matched records from the right table. The syntax looks very similar to INNER JOIN. The only difference is you're writing LEFT JOIN instead of INNER. LEFT JOIN tells SQL to return the overlap and everything from the left table. So even if there's no match, you won't lose any data from your first table. This is where you prescribe which right table you want to join to and tell the server which columns to make the match on. Here's an example. You're selecting some data from rental and then you're Left Joining to customer on rental.customer_id=customer.customer_id. So the difference here is when we used INNER JOIN, you would only get records back when there was a match. In this case, you're going to get all of the data from the rental table, even if there isn't a match, and you'll get any matches from the customer…

Contents