Cellwise · SQL track

Combining tables with JOIN

Pull related data together, like a lookup.

Related data lives in separate tables, linked by IDs. A JOIN brings them together, much like XLOOKUP does in Excel.

An inner JOIN keeps only rows with a match on both sides. A LEFT JOIN keeps everything from the first table, even when there’s no match.

What you’ll do

• Join two tables
• Join, then summarize
• Keep the ones with no match