Converts field name into database column alias.
When two or more tables are used in SELECT with
the same column name they must be distinguishable. Thus
each column name must be followed by a unique alias which is
referred later in WHERE and ORDER BY
clause and also in the result set.
In ORDER BY expressions cannot be used like
COUNT(points) instead these expressions must be
defined together with aliases in the column list right after
SELECT .
An alias must not contain dots neither it can be a SQL expression.
E.g.
description -> DESCRIPTION
mother.firstName -> MOTHER_FIRST_NAME
father.firstName -> FATHER_FIRST_NAME
total -> TOTAL
Parameters: fieldName - field name of the list. corresponding database column alias used in SQL query. |