dokuwiki

CREATE OR REPLACE VIEW v_dep_emp (
   department_name,
   first_name,
   last_name,
   employee_id,
   email,
   phone_number,
   hire_date,
   job_id,
   salary,
   commission_pct,
   manager_id,
   department_id )
AS
SELECT departments.department_name, employees.first_name, employees.last_name,
       employees.employee_id, employees.email, employees.phone_number,
       employees.hire_date, employees.job_id, employees.salary,
       employees.commission_pct, employees.manager_id,
       employees.department_id
  FROM departments, employees
 WHERE ((departments.department_id = employees.department_id))