How do you perform a JOIN in SQLite?

SQLite supports the standard SQL join types — INNER JOIN, LEFT JOIN, and (more recently) RIGHT JOIN and FULL JOIN — combining rows from two or more tables based on a matching condition.

SELECT person.name, order_item.total
FROM person
INNER JOIN order_item ON person.id = order_item.person_id;

SELECT person.name, order_item.total
FROM person
LEFT JOIN order_item ON person.id = order_item.person_id;
-- includes every person, even those with no matching order_item rows

INNER JOIN only returns rows where a match exists on both sides; LEFT JOIN returns every row from the left table regardless of whether a match exists, filling in NULLs for the right side's columns when there's no match — the same standard join semantics used across virtually every relational database.

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.

Webull! Receive free stock by signing up using the link: Webull signup.