连接查询
1.内联连
关键词:innner 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
2.外连接(左外)
关键词: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