给定如下 SQL 语句: SELECT employee.name, department.dname FROMdepartment,employee WHERE department.did=employee.did; 下面选项中,与其功能相同的是
A.
ELECT employee.name, department.dname FROMdepartment JOIN employee ON department.did=employee.did;
B.
SELECT employee.name, department.dname FROMdepartment CROSS JOIN employee ON department.did=employee.did;
C.
SELECT employee.name, department.dname FROMdepartment LEFT JOIN employee ON department.did=employee.did;
D.
SELECT employee.name, department.dname FROMdepartment RIGHT JOIN employee ON department.did=employee.did; di-language:AR-SA'>ELECT employee.name, department.dname FROMdepartment JOIN employee ON department.did=employee.did;