PrepAway - Latest Free Exam Questions & Answers

Which of the following joins is used in this query?

Angela works as a Database Administrator for AznoTech Inc. She writes the following query:
<code>
SELECT Dept_Name, Emp_Name
FROM Departments d1, Employees e1
WHERE d1.Dept_No = e1.Dept_No
ORDER BY Dept_Name, Emp_Name;
</code>
Which of the following joins is used in this query?

PrepAway - Latest Free Exam Questions & Answers

A.
Non-equijoin

B.
Outer join

C.
Equijoin

D.
Self join


Leave a Reply

Your email address will not be published. Required fields are marked *