郑维勇的博客

3.使用视图简化复杂的连接

Eg:

Create view v_employee

as

select tb_employee14.员工编号,tb_employee14.员工姓名,tb_laborage14.薪资编号,tb_laborage14.基本工资,tb_job14.请假天数

from tb_employee14 left join tb_job14

on tb_employee14.员工编号=tb_job14.员工编号

left join tb_laborage14

on tb_laborage14.员工编号=tb_job14.员工编号

Select * from v_employee