[打卡]陈天宇 多表查询

SELECT employee_id,department_name
FROM employees,departments
WHERE employees.employee_id = departments.department_name;

SELECT emloyee_id,department_name
FROM employees e,departments d
WHERE e.department_id = d.department_id(+);

SELECT employee_id,department_name
FROM employees e JOIN departments d
ON e.department_id = d.department_id;

SELECT employee_id,department_name
FROM employees e INNER JOIN departments d
ON e.department_id = d.department_id;

SELECT employee_id,department_name,city
FROM employees e JOIN departments d
ON e.department_id = d.department_id
JOIN locations l
ON d.location_id = l.location_id;

SELECT employee_id,department_name
FROM employees e LEFT OUTER JOIN departments d
ON e.department_id = d.department_id;

SELECT employee_id,department_name
FROM employees e LEFT JOIN departments d
ON e.department_id = d.department_id;

SELECT employee_id,department_name
FROM employees e RIGHT JOIN departments d
ON e.department_id = d.department_id;