[打卡]崔一博 多表查询

SELECT employee_id, last_name,department_name
FROM employees e,departments d
WHERE e.department_id=d.department_id;

SELECT * FROM employees;

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

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

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

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

SELECT 122-106;