Sam created a self join between two copies of the Employees table and then renamed one copy Managers.When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?
A) The datasheet lists employees with no managers.
B) The datasheet lists managers with no employees.
C) Employee last names are repeated many times because many employees report to the same managers.
D) Manager last names are repeated many times because many employees report to the same managers.

Question

Quizplus · Accepted Answer

Since it's a self join and one copy of the table has been renamed as Managers, when the LastName field is added from both tables, it will list the managers' last names along with employee last names they manage. Hence, Manager last names will be repeated many times as many employees report to the same managers.

Sam Created a Self Join Between Two Copies of the Employees