链接查询
内连接
inner join ... on;
- 内链例子
表1 inner join 表2 on 表1.列 = 表2.列
思路:
select * from 员工表 inner join 部门表 on 员工表.外键列 = 部门表.主键列
代码:
select * from employee inner join department on employee.department_id = department.id
外连接
左外
left join...on
- 左外例子
表1 left join 表2 on 表1.列 = 表2.列
思路:
select * from 员工表 left join 部门表 on 员工表.外键列 = 部门表.主键列
代码:
select * from employee left join department on employee.department_id = department.id
右外
right join...on
- 右外例子
表1 right join 表2 on 表1.列 = 表2.列
思路:
select * from 员工表 right join 部门表 on 员工表.外键列 = 部门表.主键列
代码:
select * from employee right join department on employee.department_id = department.id
左表与右表的区别
链接的格式
-
表1 ??? 表2
-
???代表了
- inner join
- left join
- right join
左右表
- 连接符号左边的表,是左表
- 上面例子中表1就是左表
- 连接符号右边的表,是右表
- 上例中表2就是右表