22 lines
705 B
Markdown
Executable File
22 lines
705 B
Markdown
Executable File
---
|
|
note type:
|
|
- database
|
|
- theory
|
|
date: 2026-06-03
|
|
done: true
|
|
---
|
|
# The SQL JOIN Clause
|
|
|
|
The JOIN clause is used to combine rows from two or more tables, based on a related column between them.
|
|
|
|
Here are the different types of JOINs in SQL:
|
|
|
|
- (INNER) JOIN: Returns only rows that have matching values in both tables
|
|
- LEFT (OUTER) JOIN: Returns all rows from the left table, and only the matched rows from the right table
|
|
- RIGHT (OUTER) JOIN: Returns all rows from the right table, and only the matched rows from the left table
|
|
- FULL (OUTER) JOIN: Returns all rows when there is a match in either the left or right table
|
|
|
|
![[Pasted image 20260603221345.png]]
|
|
|
|
![[Pasted image 20260619152151.png]]
|