You work as a Database Administrator for Domain.com. The company uses MySQL as the
database platform. You have created a table named Students in the database. The structure of the
table is as follows:
Stu_ID NUMBER (3) PRIMARY KEY
Stu_Name VARCHAR2 (25) NOT NULL
Fee NUMBER (8, 2)
Class NUMBER (5);
You have executed the following statement for the table “Students”:
SELECT e.Stu_Name, m.Fee
FROM Students e, Students m
WHERE e.Stu_ID = m.stu_ID;
Which of the following join types have you used in the above statement?
A.
Cross join
B.
Equijoin
C.
Self join
D.
Outer join