【单选题】
A SELECT e.first_name,d.department_name FROM employees e RIGHT JOIN departments d ON e.department_id=d.department_id
B SELECT e.first_name,d.department_name FROM employees e LEFT JOIN departments d ON e.department_id=d.department_id
C SELECT e.first_name,d.department_name FROM employees e INNER JOIN departments d ON e.department_id=d.department_id
D SELECT e.first_name,d.department_name FROM employees e BETWEEN JOIN departments d ON e.department_id=d.department_id
查看更多