AnswersDRHS-Business and Tech BLOCK 07.4410030Joining TablesQuestion 4
4
AssignmentMultiple Choice

Joining Tables

Question 4 • DRHS-Business and Tech BLOCK (07.4410030)

When creating a self-join query in Design view, what is the benefit of giving one of the tables an alias?

Answer
A
An alias is necessary because the tables will be overwritten or deleted.
B
An alias is necessary because the query will use two sets of primary keys.
C
An alias is helpful because having two copies of the same table can be confusing.
D
An alias is helpful because both tables will be deleted after the query is completed.

Explanation

A self-join uses the same table twice so that records in that table can be compared or related to other records in it. Giving one copy an alias lets you distinguish the two copies when choosing fields and setting join conditions, reducing confusion. The tables are not overwritten or deleted when you create the query.

AI-written and checked against the verified answer.

Previous
Next

More from this Course

Assignment
14 verified answers

Instruction

Assignment
14 verified answers

Instruction

Assignment
8 verified answers

Designing a Relational Database