[打卡]多表查询4.12

SELECT employee_id, last_name,department_name,city
FROM employees,departments,locations
WHERE employees.department_id = departments.department_id AND departments.location_id = locations.location_id;

SELECT * FROM job_grades;

SELECT last_name,salary,grade_level
FROM employees,job_grades
WHERE employees.salary BETWEEN job_grades.lowest_sal AND job_grades.highest_sal;

SELECT e.last_name,e.salary,j.grade_level
FROM employees e,job_grades j
WHERE e.salary >= j.lowest_sal
AND e.salary <= j.highest_sal;

SELECT * from employees;

SELECT emp.employee_id,emp.last_name,mgr.employee_id,mgr.last_name
FROM employees emp,employees mgr
WHERE emp.manager_id = mgr.employee_id;