Содержание
- 2. JOIN INNER OUTER LEFT OUTER RIGHT OUTER FULL OUTER CROSS 18.11.2017 Горбунов О.Е.
- 3. INNER JOIN SELECT table1.column, table2.column, … FROM table1 [INNER] JOIN table2 ON ( ); SELECT e.employee_id,
- 4. INNER JOIN SELECT employee_id, city, department_name FROM employees e JOIN departments d ON d.department_id = e.department_id
- 5. INNER JOIN SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id FROM employees e JOIN departments d ON (e.department_id
- 6. INNER JOIN SELECT e.last_name, e.salary, j.grade_level FROM employees e JOIN job_grades j ON e.salary BETWEEN j.lowest_sal
- 7. OUTER JOIN SELECT table1.column, table2.column, … FROM table1 LEFT|RIGHT|FULL OUTER JOIN table2 ON (table1.column_name = table2.column_name);
- 8. OUTER JOIN SELECT e.last_name, e.department_id, d.department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id
- 10. Скачать презентацию