mirror of
https://github.com/ByteByteGoHq/system-design-101.git
synced 2026-04-03 01:17:23 -04:00
ee4b7305a2
This PR adds all the guides from [Visual Guides](https://bytebytego.com/guides/) section on bytebytego to the repository with proper links. - [x] Markdown files for guides and categories are placed inside `data/guides` and `data/categories` - [x] Guide links in readme are auto-generated using `scripts/readme.ts`. Everytime you run the script `npm run update-readme`, it reads the categories and guides from the above mentioned folders, generate production links for guides and categories and populate the table of content in the readme. This ensures that any future guides and categories will automatically get added to the readme. - [x] Sorting inside the readme matches the actual category and guides sorting on production
33 lines
809 B
Markdown
33 lines
809 B
Markdown
---
|
|
title: "How do SQL Joins Work?"
|
|
description: "Learn how SQL joins work with detailed explanations and examples."
|
|
image: "https://assets.bytebytego.com/diagrams/0367-top-4-types-of-sql-joins.png"
|
|
createdAt: "2024-03-11"
|
|
draft: false
|
|
categories:
|
|
- technical-interviews
|
|
tags:
|
|
- "SQL"
|
|
- "Database"
|
|
---
|
|
|
|
|
|
|
|
The diagram above shows how 4 types of SQL joins work in detail.
|
|
|
|
## INNER JOIN
|
|
|
|
Returns matching rows in both tables.
|
|
|
|
## LEFT JOIN
|
|
|
|
Returns all records from the left table, and the matching records from the right table.
|
|
|
|
## RIGHT JOIN
|
|
|
|
Returns all records from the right table, and the matching records from the left table.
|
|
|
|
## FULL OUTER JOIN
|
|
|
|
Returns all records where there is a match in either left or right table.
|