Join related records
Combine records using explicit relationships.
Example
Section titled “Example”CREATE TABLE docs_accounts (id BIGINT PRIMARY KEY, name TEXT);CREATE TABLE docs_requests (id BIGINT PRIMARY KEY, account_id BIGINT, title TEXT);INSERT INTO docs_accounts VALUES (7, 'Acme');INSERT INTO docs_requests VALUES (1, 7, 'Review request');SELECT a.name, r.titleFROM docs_accounts aJOIN docs_requests r ON r.account_id = a.idORDER BY r.id;Behavior
Section titled “Behavior”The result combines Acme and Review request. An inner join excludes unmatched rows. Use a left join when unmatched records must remain. Ensure the join key has the cardinality your application expects.
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License