SQL ALIASES
SQL ALIASES Description SQL ALIASES can be used to create a temporary name for columns or tables. COLUMN ALIASES are used to make column headings in your result set easier to read. TABLE ALIASES are used to shorten your SQL to make it easier to read or when you are performing a self join (ie: listing the same table more than once in the FROM clause). Syntax The syntax to ALIAS A COLUMN in SQL is: column_name AS alias_name OR The syntax to ALIAS A TABLE in SQL is: table_name alias_name Parameters or Arguments column_name is the original name of the column that you wish to alias. table_name is the original name of the table that you wish to alias. alias_name is the temporary name to assign. Note If the alias_name contains spaces, you must enclose the alias_name in quotes. It is acceptable to use spaces when you are aliasing a column name. However, it is not generally good practice to use spaces when you are aliasing a table name. The alias_name is only valid within...