How Data is Stored and Moved

Join

Combining data from two or more database tables based on a related column.

Definition

Combining data from two or more database tables based on a related column. Joins are what make relational databases powerful — they let you connect related information stored in separate places.

Example

A 'students' table and a 'grades' table are separate, but both have a student_id column. A JOIN lets you combine them to see each student's name alongside their grades.

See it in context Learn how Join fits into the bigger picture of how software actually works.

Read the Guide →