Inner join
Left outer join
Right outer join
Self join
Answer is Wrong!
Answer is Right!
The answer is A. Inner join.
An inner join displays records from both tables where there is a match on the common field.
A left outer join displays all records from the left table, even if there is no match in the right table.
A right outer join displays all records from the right table, even if there is no match in the left table.
A self join displays records from the same table that have a match on the common field.