SELECT employees.employee_id, employees.last_name,
SELECT employees.employee_id, employees.last_name,
SELECT employees.employee_id, employees.last_name,
SELECT employees.employee_id, employees.last_name,
employees.department_id, departments.department_id,
employees.department_id, departments.department_id,
employees.department_id, departments.department_id,
employees.department_id, departments.department_id,
departments.location_id
departments.location_id
departments.location_id
departments.location_id
FROM employees, departments
FROM employees, departments
FROM employees, departments
FROM employees, departments
WHERE employees.department_id = departments.department_id;
WHERE employees.department_id = departments.department_id;
WHERE employees.department_id = departments.department_id;
WHERE employees.department_id = departments.department_id;
等值连接
…
…
…
…