给定如下SQL语句:SELECT employee.name, department.dname FROM department,employee WHERE department.did=employee.did;
B.
SELECT employee.name, department.dname FROM department JOIN employee ON department.did=employee.did;
C.
SELECT employee.name, department.dname FROM department CROSS JOIN employee ON department.did=employee.did;
D.
SELECT employee.name, department.dname FROM department LEFT JOIN employee ON department.did=employee.did;
E.
SELECT employee.name, department.dname FROM department RIGHT JOIN employee ON department.did=employee.did;