SQLite LEFT JOIN

The SQLite LEFT JOIN is used to return all records from the left table, even if there is no match with the right table.

Syntax

The SQLite LEFT JOIN syntax is as follows:

SELECT column1, column2, ...
FROM left_table
LEFT JOIN right_table ON condition;

Example

Table of students

Table of student_address

In the following example, the query uses a LEFT JOIN between the students table and student_address. According to the LEFT JOIN definition, the select will return all records from the students table, even if there are students without a completed address, more precisely address_id does not find a corresponding value in the student_address table.

SELECT s.*
FROM students s LEFT JOIN student_address sa 
ON s.address_id = sa.address_id ;

Output