内联接，左联接，右联接和完全联接有什么区别？ [重复]

Question

This question already has an answer here:

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

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

</div>

转载于:https://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join

Answer 1

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

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

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