---
title: "Discussion on \"深入理解MySQL的LEFT JOIN：ON与WHERE条件的正确使用\" | Hashnode"
description: "Discussion on \"深入理解MySQL的LEFT JOIN：ON与WHERE条件的正确使用\". 了解MySQL使用LEFT JOIN时ON与WHERE条件的区别，确保查询不出错，提供详尽实例与场景分析。"
url: "https://hashnode.com/posts/mysql-left-join-on-vs-where/68d6049385f94d2245476d0d"
---

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

Discussion

# [深入理解MySQL的LEFT JOIN：ON与WHERE条件的正确使用](https://hello1024.hashnode.dev/mysql-left-join-on-vs-where?utm_source=hashnode&utm_medium=feed)

了解MySQL使用LEFT JOIN时ON与WHERE条件的区别，确保查询不出错，提供详尽实例与场景分析。

Mar 12, 2020 · 2 min read · hello1024.hashnode.dev  
Read the article

-   [#mysql](https://hashnode.com/tag/mysql)
-   [#left-join](https://hashnode.com/tag/left-join)

## Written by

[hello1024](https://hashnode.com/@hello1024)

@hello1024

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

Exploring Work Life Balance. 探索工作与生活的平衡

I am ZhangSan, a mere nobody. 我是张三，一个无名小子。

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
