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;