Define table aliases

Table aliases are required only if you are using a self-join or writing a SELECT expression on a table column.

  1. In the Define Table Alias tab, select the table from the drop-down list.
  2. Enter an alias. The alias cannot be longer than three characters.

    The system displays the alias in the Selected Columns tab.

  3. If you need another alias, click the Icon is a plus sign.Add Table Alias icon.
  4. Click OK.