SELECT AS can be used to create a temporary name for columns or tables.
To create a temporary name for columns or tables, use the following syntax:
tablename: The original name of the table that you wish to alias.
column_name: The column name that you wish to alias.
alias_name: The temporary name to assign.
In the above example, we have created alias for the "firstNAme" column.
In the above example, we have created an alias for the "tblCustomerLoan" table called p and c for "tblCustomer" table.