MySQL-外连接

# 外连接
CREATE TABLE stu(
	id INT,
	`name` VARCHAR(32));
INSERT INTO stu VALUES(1,'jack'),(2,'tom'),(3,'kity'),(4,'cyt');

CREATE TABLE exam(
	id INT,
	`grade` INT);
INSERT INTO exam VALUES(1,56),(2,76),(3,100),(11,75);

SELECT stu.id,`name`,grade -- 多表查询，但不显示4
	FROM stu,exam
	WHERE stu.id = exam.id

-- 左外连接,左边显示满，没成绩也要显示,left join..on..
SELECT stu.id,`name`,grade 
	FROM stu LEFT JOIN exam
	ON stu.id = exam.id

-- 右外连接,没人也要显示成绩
SELECT stu.id,`name`,grade 
	FROM stu RIGHT JOIN exam
	ON stu.id = exam.id