mysql 连接查询

1.inner join

SELECT a.*,b.*
FROM table_a a
INNER JOIN table_b b
ON a.id=b.id

2.left join

SELECT a.*,b.*
FROM table_a a
LEFT JOIN table_b b
ON a.id=b.id

3.right join

SELECT a.*,b.*
FROM table_a a
RIGHT JOIN table_b b
ON a.id=b.id

4.左内联

SELECT a.*,b.*
FROM table_a a
LEFT JOIN table_b b
ON a.id=b.id
WHERE b.id IS NULL

5.右内联

SELECT a.*,b.*
FROM table_a a
RIGHT JOIN table_b b
ON a.id=b.id
WHERE a.id IS NULL

6.子连查询
自连接查询就是把一张表模拟成左右两张表，然后进行连表查询。
自连接查询必须对表起别名

select c.id, c.title, c.pid, p.title from areas as c inner join areas as p on c.pid = p.id where p.title = '山西省';

参考：
https://www.cnblogs.com/hitechr/p/10408085.html