Joins (JOIN)
Combining two tables on a common column and querying them together.
Simple enough for a 5-year-old to understand
INNER JOIN
Connects related tables (e.g., person + order) using a common key.
CREATE TABLE person(id INTEGER, name TEXT);CREATE TABLE orders(person_id INTEGER, item TEXT);INSERT INTO person VALUES (1, 'Alex');INSERT INTO orders VALUES (1, 'Pencil');SELECT person.name, orders.item FROM person JOIN orders ON person.id = orders.person_id;