Using Qualified Identifiers Consistently

When qualifying a column name and table name in the same statement, be sure to use the same qualifying expressions for each; they are evaluated as strings and must match; otherwise, an error is returned.

Example 1

select from demo.mary.publishers
city ----------------------- Boston Washington Berkeley

Example 2

This example is incorrect because the syntax style for the column name does not match the syntax style used for the table name.

select from demo..publishers
The column prefix "demo.mary.publishers" does not match a table name or alias name used in the query.