#案例:查询员工名、部门名
SELECT
last_name,department_name
FROM
employees e
INNER JOIN
departments d
ON
e.`department_id`=d.`department_id`SELECT
last_name,department_nam#案例:查询员工名、部门名
SELECT
last_name,department_name
FROM
employees e
INNER JOIN
departments d
ON
e.`department_id`=d.`department_id`SELECT
last_name,department_nam