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:

STUDENT_IDSTUDENT_NAMESTUDENT_SUBJECT
1TomFrench
2JerryPhysics
3BrunoEnglish

TEACHERS Table:

IDNAMESALARYSUBJECT
1Jim10000Geology
2John20000Geology
3Watson15000Physics
4Holmes25000Chemistry
5Tony30000Physics
SELECT ID, STUDENT_NAME, NAME, SUBJECT
FROM STUDENTS 
INNER JOIN TEACHERS  
ON STUDENTS.STUDENT_SUBJECT = TEACHERS.SUBJECT;

Output:

IDSTUDENT_NAMENAMESUBJECT
3TomWatsonFrench
5JerryTonyPhysics
1BrunoJimEnglish

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.

Please Share