A self-join in a query requires the use of alias names in the FROM clause to distinguish between the two copies of the table.

Name: A self-join in a query requires the use of alias names in the FROM clause to distinguish between the two copies of the table.
Brand: Quizplus
Rating: 4.9 (37 reviews)

Question

Quizplus · Accepted Answer

This is true because in a self-join, the table is joined with a copy of itself, and without alias names, it would be unclear which instance of the table is being referred to in the query.

A Self-Join in a Query Requires the Use of Alias