MySQL 基础篇

学习网站推荐

W3C：https://www.w3schools.com/mysql/mysql_join_self.asp

Join

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• CROSS JOIN
• SELF JOIN

Join地图

SELF JOIN

SELECT column_name(s)
FROM table1 T1, table1 T2
WHERE condition;