In a SELECT SQL statement,if two fields from two different tables have the same name,what follows the table name prefix?
A)Dot (. )
B)Comma (,)
C)Apostrophe (')
D)Quotation marks (")

Question

Quizplus · Accepted Answer

A dot (.) follows the table name prefix to differentiate between two fields with the same name from two different tables. For example, if we have a field named "ID" in both "employees" and "customers" tables, we can distinguish between them by referring to them as "employees.ID" and "customers.ID".

In a SELECT SQL Statement,if Two Fields from Two Different