How to create a table alias (Enterprise Manager)

To create a table alias

1. Add the input sources to your query.
2. In the FROM clause in the SQL pane, add the alias name to each table you are creating an alias for. For example, to assign the alias “e” to the employee_information table and “p” to the positions table, you can create a FROM clause such as the following:

   FROM employee_information e, positions p

When you create a table alias, the Query Designer substitutes the alias for the corresponding table name in the Table column of the Grid pane.