Inner Join - SQL Programming

An inner join combines rows when keys match in both tables.

Program

Play the query to connect customers to their orders.

inner_join.sql

CREATE TABLE customers (id INTEGER, name TEXT);
CREATE TABLE orders (id INTEGER, customer_id INTEGER, total INTEGER);
INSERT INTO customers VALUES (1, 'Ada'), (2, 'Lin');
INSERT INTO orders VALUES (101, 1, 30), (102, 2, 12);
SELECT customers.name, orders.id, orders.total FROM customers JOIN orders ON customers.id = orders.customer_id ORDER BY orders.id;

JOIN `JOIN` combines tables.

ON `ON customers.id = orders.customer_id` is the matching rule.

qualified name `orders.id` chooses the `id` column from `orders`.