Fully Qualified Names in SQL

We can provide the table name just before the column name in the line. We’ll separate each other using dot.

SELECT customers.City FROM customers;

We can provide more columns to the user. See:

SELECT customers.City, customers.Address FROM customers;

-Its useful practice when working on many tables that may have the same columns (same column names).

Link:

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all