Introduction to SQL Joins
Objectives
- Understand what SQL Joins are.
- Learn about different types of SQL Joins.
- Practice joining tables
What are SQL Joins?
SQL Joins are used to combine data from two or more tables based on a related column between them.
Types of SQL Joins
There are different types of SQL Joins, including:
Join Type | Description |
---|---|
INNER JOIN | Returns rows when there is a match in both tables. |
LEFT JOIN | Returns all rows from the left table and the matched rows from the right table. |
RIGHT JOIN | Returns all rows from the right table and the matched rows from the left table. |
FULL JOIN | Returns rows when there is a match in one of the tables. |