In a relational database, data is organized in tables. Each table consists of rows and columns, with each row representing a unique record. Tables can be related to each other through keys, typically primary and foreign keys. Joins allow us to combine rows from two or more tables based on a related column between them.
There are several types of joins, each serving a different purpose: