[打卡]多表查询董

SELECT last_name,department_name from employees e,departments d WHERE e.department_id=d.department_id;
SELECT * FROM employees;
SELECT e.employee_id,e.last_name,d.department_name,l.city FROM employees e,departments d,locations l WHERE e.department_id=d.department_id AND d.location_id=l.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 last_name,salary,grade_level 
from employees,job_grades
where employees.salary>= job_grades.lowest_sal and employees.salary<=job_grades.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;