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