SQLite INNER JOIN

The SQLite INNER JOIN is a join where the values in the join columns are compared using an equals comparison operator. An inner join returns all rows from both tables that match the specified join condition.

Syntax

The SQLite INNER JOIN syntax is as follows:

SELECT column1, column2, ...
FROM table1
INNER JOIN table2 ON condition1;

Example

Table of students

Table of student_address

In the following example, the query uses INNER JOIN between the students table and student_address. The condition of the select is that address_id has the same values in both tables. Students without an address will not appear in the query result.

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

Output