例1:
select e.last_name,e.first_name,d.dept_name
from employees as e
left join dept_emp as de on e.emp_no=de.emp_no
left join departments as d on de.dept_no=d.dept_no;
例2:
select dept_emp.dept_no,employees.emp_no,salary
from employees
left join dept_emp
on employees.emp_no=dept_emp.emp_no
left join salaries
on employees.emp_no=salaries.emp_no
WHERE dept_emp.to_date='9999-01-01'
AND salaries.to_date='9999-01-01'
and employees.emp_no not in(
select emp_no
from dept_manager
WHERE to_date='9999-01-01');