Courses / SQL
10. LEFT JOIN
A type of join that returns all rows from the left table and matched rows from the right table.
1 min read Chapter 10 of 29
SQL
LEFT JOIN
A LEFT JOIN returns all records from the left table and matched records from the right table.
"I need to see all my customers, even if they haven't made any orders."
A LEFT JOIN is a SQL operation that retrieves all rows from the left table and the matched rows from the right table, filling in NULLs where there are no matches.
"I need to see all my customers, even if they haven't made any orders."
A LEFT JOIN is a SQL operation that retrieves all rows from the left table and the matched rows from the right table, filling in NULLs where there are no matches.