【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-299.sql,希望本篇文章对您学习有所帮助。
use db_
sql go
create view v_employee
as
select tb_employee14.员工编号,tb_employee14.员工,
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
alter view v_employee
as
select tb_employee14.员工编号,tb_employee14.员工,
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.员工编号
where tb_laborage14.基本工资 > 1000