mysql - INNER JOIN，LEFT JOIN，RIGHT JOIN和FULL JOIN有什么区别？ [重复](What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate])

Question

This question already has an answer here:

(这个问题已经在这里有了答案：)

• What is the difference between “INNER JOIN” and “OUTER JOIN”?

  (“ INNER JOIN”和“ OUTER JOIN”有什么区别？)

  25 answers

  (25个答案)

What's the difference between INNER JOIN , LEFT JOIN , RIGHT JOIN and FULL JOIN in MySQL ?

(MySQL中的 INNER JOIN ， LEFT JOIN ， RIGHT JOIN和FULL JOIN什么区别？)

  ask by Lion King translate from so

Answer 1

Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins .

(阅读有关代码项目的原始文章将对您有很大帮助： SQL Joins的可视表示 。)

Also check this post: SQL SERVER – Better Performance – LEFT JOIN or NOT IN?

(还请检查此帖子： SQL SERVER –更好的性能–左联接还是不联接？)

.

(。)

Find original one at: Difference between JOIN and OUTER JOIN in MySQL .

(在以下位置找到原始版本： MySQL中的JOIN和OUTER JOIN之间的区别 。)