SQLite INNER JOIN operation

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:

This was an example of a INNER JOIN query in SQLite.