给定如下SQL语句：SELECT employee.name, department.name FROM department, employee WHERE department.did=employee.did;下面选项中，与其功能相同的是

题目：给定如下SQL语句：SELECT employee.name, department.name FROM department, employee WHERE department.did=employee.did;下面选项中，与其功能相同的是

A. SELECT employee.name, department.dname FROM department JOIN employee ON department.did=employee.did;

B. SELECT employee.name, department.dname FROM department CROSS JOIN employee ON department.did=employee.did;

C. SELECT employee.name, department.dname FROM department LEFT JOIN employee ON department.did=employee.did;

D. SELECT employee.name, department.dname FROM department RIGHT JOIN employee ON department.did=employee.did;

答案：评论后可见此内容