SQL多表连接

最新推荐文章于 2024-07-25 18:23:42 发布

Biting_W

最新推荐文章于 2024-07-25 18:23:42 发布

阅读量405

点赞数

本文链接：https://blog.csdn.net/Biting_W/article/details/100008980

版权

多表链接

在这里插入图片描述

SELECT * FROM employee WHERE id=1

内连接：

SELECT e.id,e.name AS '员工名',d.name AS '部门' FROM employee e,department d WHERE  e.depno = d.id  ;

外连接（左连接，右连接）：

SELECT e.id,e.name AS '员工名',d.name AS '部门' FROM employee e INNER JOIN department d ON e.depno = d.id  ;

左连接

SELECT e.id,e.name AS '员工名',d.name AS '部门'  FROM employee e  LEFT OUTER JOIN department d ON e.depno = d.id  ;

SELECT e.id,e.name AS '员工名',d.name AS '部门'  FROM employee e  LEFT OUTER JOIN department d ON e.depno = d.id ;

SELECT e.id,e.name AS '员工名',d.name AS '部门'  FROM employee e  RIGHT OUTER JOIN  department d ON e.depno = d.id