Inner Join in SQLite

SQLite Inner Join
To combine all rows from multiple tables, the SQLite Inner join is used. However, it joins only those rows where the join condition is satisfied. It is the simplest, most popular and the default type of Join in SQLite.

Syntax 1:

SELECT columns
FROM table_1 
INNER JOIN table_2 
ON conditions

Syntax 2:

SELECT columns
FROM table_1  
JOIN table2 
USING ( column_1 ,... ) ...   

Syntax 3:

SELECT columns
FROM table_1   
NATURAL JOIN table2...  

Example:
STUDENTS Table:

TEACHERS Table:

SELECT ID, STUDENT_NAME, NAME, SUBJECT
FROM STUDENTS 
INNER JOIN TEACHERS  
ON STUDENTS.STUDENT_SUBJECT = TEACHERS.SUBJECT;

Output:

Explanation: 

In the above example, the records from the ID, NAME and the SUBJECT Columns of the TEACHERS table and the STUDENT_NAME column of the STUDENTS table is fetched and joined where the value of the STUDENT_SUBJECT column of the STUDENTS table is equal to the SUBJECT column of the TEACHERS table.