Add table aliases

Columns used in an expression must have a 3-character table alias.

  1. In the Define Table Alias tab, select the table from the drop-down list.
  2. Enter the alias. The alias cannot be longer than three characters.
  3. If you need an additional alias, click the Icon is a plus sign.Add Table Alias icon.

    Tip:

    If you modify an alias later, any expressions or criteria that refer to the old alias are updated during the Save operation. If an expression or criteria already saved refers to a deleted alias, update it manually. To work with the expression or criteria before saving, update it manually.