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. If not done already, open the custom listing you created in Define query details.
2. In the Define Table Alias tab, select the table from the drop-down list.
3. Enter an alias. Use an alias with three characters or less.

   The system displays the alias in the Selected Columns tab.

4. If necessary, click View to access options to see all or specific columns, detach the table, sort, or reorder columns. (For more details on customizing the view, see Customize the user interface display.) You can also use the following icons in the toolbar to do the following:
   • The Delete Column icon deletes the selected column.
   • The Add Table Alias to add another alias.
   • The Remove Table Alias icon deletes the alias.
   • The Detach icon detaches the table from the page for you to see the whole table. Click X in the upper-right corner to close it.
5. Click OK.
6. Do one of the following:
   • Continue on to Specify and test criteria to continue defining your custom listing.
   • Click OK to close the dialog box and save the custom listing with the details you entered. You can return to this procedure and search for it to continue defining it later.

Next: Specify and test criteria.