Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+<code>
+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))
+</code>

dokuwiki