Abstract: the join? left join? right join? inner join? outer join? There are too many joins. Do you understand the differences and connections between various joins? This article uses simple examples to describe the differences and connections between various joins. I hope it will be helpful for you. Meanwhile, please kindly point out any mistakes in this article.