给定如下SQL语句:SELECT employee.name, department.dname FROM department,employee WHERE department.did=employee.did;
A.选项中,与其功能相同的是
B.SELECTemploye
E.name,department.dnameFROMdepartmentJOINemployeeONdepartment.did=employe
E.did;
C.SELECTemploye
E.name,department.dnameFROMdepartmentCROSSJOINemployeeONdepartment.did=employe
E.did;
D.SELECTemploye
E.name,department.dnameFROMdepartmentLEFTJOINemployeeONdepartment.did=employe
E.did;
E.SELECTemploye
E.name,department.dnameFROMdepartmentRIGHTJOINemployeeONdepartment.did=employe
E.did;