While we have demonstrated that we can retrieve data from our
Companylink database, we have not, thus far, been able to alter the way the data is presented. As we move through the book, we will discover more ways to customize our output, but one way we can do this now is through the use of an alias. An alias is an alternate name given to a column that alters the way it is displayed. To demonstrate this, let's examine another one of our
Companylink tables: the
award table. The following example shows a query from the
award table that selects its two columns but uses no alias:
For the first time, ...