Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

LEFT OUTER JOIN
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

A LEFT OUTER JOIN in SQL is a type of join that combines rows from two or more tables based on a specified condition, and includes all rows from the left (or first) table, regardless of whether there is a match in the right (or second) table. If there is no match, NULL values are filled in for columns from the right table.

Syntax

SELECT * 
FROM table1
LEFT JOIN table2 
ON table1.column_name = table2.column_name;

Example

Consider we have two tables, students and grades, with information about students and their respective grades:

Now, let's perform a LEFT OUTER JOIN

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible