Which of the following types of joins displays records with the same value in the common field? A. Inner join B. Left outer join C. Right outer join D. Self join

Inner join
Left outer join
Right outer join
Self join

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.

Exit mobile version