You can perform a INNER JOIN query in SQLite by using the INNER JOIN keyword, followed by table name of the table to join with, and the ON keyword, followed by the condition defining the relationship between the tables.
SELECT city, country FROM orders INNER JOIN clients ON clients.client_id = orders.customer_id;
Above operation will return all city and country data for which a client_id in clients table matches customer_id in orders table. I.e. only those rows are returned for which these two values match.
There are other JOIN types in SQLite:
- SQLite LEFT JOIN
- SQLite INNER JOIN
This was an example of a INNER JOIN query in SQLite.