Data Source Aliases

If you assign an alias to a data source, you will be able to access this source using the alias in the future (and you will not be able to access it by the table name). This can be more convenient, and in some cases it is the only option.

Aliases are defined according to rules for assigning identifier variables. Aliases in a query cannot be the same.

The AS keyword can precede the source alias. You can omit this word at all, but when indicated it improves the clarity and readability of the query text.

Assigning aliases in itself does not affect data selection in the query.

Example.

SELECT
   Product.Name,
   Article.Parent

FROM
  Catalog.Nomenclature AS Article

This example demonstrates the use of the Article alias assigned to the Catalog.Nomenclature source table in the selection fields list.