sy1_4_2.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 5 行

create view view_pay
     as
       select year,month,person.no,name,sex,professor,deptname,base,bonus,deduct,fact
       from person,pay,dept
       where person.no=pay.no and person.deptno=dept.deptno