DML-select-Alias:

nSQL aliases can be used with database tables and with database table columns, depending on task you are performing.

Syntax:

SELECT column_name(s) FROM table_name AS alias_name

SELECT column_name AS alias_name FROM table_name

Query:

üSELECT Empname FROM Emptbl1 AS Employeetable1

Emptbl2 AS Employeetable2 WHERE EMPname=‘Batista' AND salary=’20,000'

üSELECT EMPname as Employee Name from Emptbl1