What is SQLite INNER JOIN?
SQLite INNER JOIN is simplest and most common join. It combines all rows from both tables where the condition is satisfied.
Syntax:
SELECT ... FROM table1 [INNER] JOIN table2 ON conditional_expression ...
