Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Manipulation Language : Working with join operations : Using inner joins : Employing a table alias
Employing a table alias
Notice that in the previous query, each column name uses the standard naming convention of table-name.column-name. This can be cumbersome and prone to errors, especially with complex joins. A more convenient way is to define table aliases in the WHERE clause and invoke them throughout the query. The following example modifies the inner join in the previous example by employing table aliases.
SELECT o.ordernum, o.custnum,, o.orderdate, o.shipdate
FROM order o INNER JOIN customer c
ON o.custnum = c.custnum;