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

When selecting columns from multiple tables with the same name, it is necessary to precede them with their table names and a dot to distinguish which table the column is coming from. For example, if we have two tables named "employees" and "departments" with a column named "name" in both tables, the query would look like this: SELECT employees.name, departments.name FROM employees, departments.

If a Query Includes Columns from Multiple Tables That Have