---
title: "Discussion on \"INNER JOIN vs LEFT JOIN: Which Rows Survive?\" | Hashnode"
description: "Discussion on \"INNER JOIN vs LEFT JOIN: Which Rows Survive?\". Most JOIN confusion comes down to one question: what happens to rows with no match? Here's how INNER and LEFT JOIN answer it, and how to choose."
url: "https://hashnode.com/posts/inner-join-vs-left-join-which-rows-survive/6af295b2a80a3f823560c3b9"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [INNER JOIN vs LEFT JOIN: Which Rows Survive?](https://systemcraftpress.hashnode.dev/inner-join-vs-left-join-which-rows-survive?utm_source=hashnode&utm_medium=feed)

Most JOIN confusion comes down to one question: what happens to rows with no match? Here's how INNER and LEFT JOIN answer it, and how to choose.

6d ago · 5 min read · systemcraftpress.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#database](https://hashnode.com/tag/database)
-   [#beginners](https://hashnode.com/tag/beginners)
-   [#tutorial](https://hashnode.com/tag/tutorial)

## Written by

[SystemCraftDev](https://hashnode.com/@systemcraftdev)

@systemcraftdev

  
[View profile](https://hashnode.com/@systemcraftdev)

Building practical Companion Guides for developers (Git, Python, JavaScript, SQL, VS Code, the command line) at systemcraftpress.com.

Building practical Companion Guides for developers (Git, Python, JavaScript, SQL, VS Code, the command line) at systemcraftpress.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
