联接视图--查询

create or replace view vw_employee_salary

as

select e.employee_id, e.last_name || e.first_name as employee_name,

e.salary + s.total_price *0.1 as salary

 

from employees e, employee_sales s

 

where e.employee_id = s.sale_by

and s.sale_month = '3月'