Zend
200-530 · Question #412
Angela works as a Database Administrator for AznoTech Inc. She writes the following query: SELECT Dept_Name, Emp_Name FROM Departments d1, Employees e1 WHERE d1.Dept_No = e1.Dept_No ORDER BY…
The correct answer is A. Equijoin. See the full explanation below for the reasoning.
Question
Angela works as a Database Administrator for AznoTech Inc. She writes the following query: SELECT Dept_Name, Emp_Name FROM Departments d1, Employees e1 WHERE d1.Dept_No = e1.Dept_No ORDER BY Dept_Name, Emp_Name; Which of the following joins is used in this query?
Options
- AEquijoin
- BSelf join
- CNon-equijoin
- DOuter join
How the community answered
(38 responses)- A76% (29)
- B13% (5)
- C5% (2)
- D5% (2)
Community Discussion
No community discussion yet for this question.