前言

希望不会再忘记

user表

order表

left join

SELECT
	*
FROM
	`user` a
LEFT JOIN `order` b ON a.id = b.uid;

right join

SELECT
	*
FROM
	`user` a
RIGHT JOIN `order` b ON a.id = b.uid;

inner join

SELECT
	*
FROM
	`user` a
INNER JOIN `order` b ON a.id = b.uid;

后续

痛心成长点滴记录