You can change the name of a column in the query results. For example, the name of a column in a table may be "PRODID" and you would like the name to appear as the name of the product, "Lamps" in the query results.
To change the name of the column in the query results: