Courses / SQL
11. RIGHT JOIN
A type of join that returns all rows from the right table and matched rows from the left table.
1 min read Chapter 11 of 29
SQL
RIGHT JOIN
A RIGHT JOIN retrieves all records from the right table and matched records from the left table.
"I want to see all customers even if they haven't placed any orders."
A RIGHT JOIN returns every row from the right table and the corresponding rows from the left table, filling in NULLs where there are no matches.
"I want to see all customers even if they haven't placed any orders."
A RIGHT JOIN returns every row from the right table and the corresponding rows from the left table, filling in NULLs where there are no matches.