【SQL开源代码栏目提醒】:本文主要为网学会员提供297.sql,希望对需要297.sql网友有所帮助,学习一下!
use db_sql
go
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.员工编号
go
select * from v_employee