<< Prev Question Next Question >>

Which three statements are true about a self join? (Choose three.)

A. The query must use two different aliases for the table

B. It must be an equijoin

C. It can be an outer join

D. It must be an inner join

E. The ON clause must be used

F. The ON clause can be used

Flavio Melo - Apr 28, 2021

I would like to understand why "The ON clause can be used" and not "The ON clause must be used"??? My answer was A, C and E.

Download PDF File