Which of the following statements is correct for equijoin used to join two tables named Employees
and Department?
A.
SELECT Dept_Name, Emp_Name
FROM Departments d1, Employees e1
ORDER BY Dept_Name, Emp_Name;
B.
SELECT D.Dept_Name, E.Emp_Name
FROM Departments d1, Employees e1
HAVING Dept_Name, Emp_Name;
C.
SELECT E.Emp_Name, D.Dept_Name
FROM Departments d1, Employees e1
WHERE Dept_No = Dept_No
ORDER BY Dept_Name, Emp_Name;
D.
SELECT Dept_Name, Emp_Name
FROM Departments d1, Employees e1
WHERE d1.Dept_No = e1.Dept_No
ORDER BY Dept_Name, Emp_Name;