If a query includes columns from multiple tables that have the same name,the statement must precede those column names with _________.
A)their database names.
B)their database names and a dot.
C)their table names and a dot.
D)their table names.

Question

Quizplus · Accepted Answer

Preceding the column names with their table names and a dot helps to avoid ambiguity and ensures that the query retrieves the correct data from the intended table. It also helps to distinguish between columns with the same name that may exist in different tables.

If a Query Includes Columns from Multiple Tables That Have