You start creating a(n) _____ join in Query Design view by adding two copies of the same table to the Query window.
A) inner
B) outer
C) self
D) unified

Question

Quizplus · Accepted Answer

When creating a self join, you add two copies of the same table to the Query window and give them separate aliases to distinguish between them. This type of join is used when you need to join a table with itself, typically to compare one set of values to another set within the same table. Inner and outer joins involve joining tables that are not the same as each other. Unified join is not a standard term.

You Start Creating A(n) _____ Join in Query Design View