|
<< Click to Display Table of Contents >> Column correlation names w. spaces |
  
|
|
<< Click to Display Table of Contents >> Column correlation names w. spaces |
|
The original Local SQL documentation says column correlation names are not allowed to be quoted nor to include spaces.
However, BDE 5.2.0.2 also accepts both provided the correlation name is prefixed with the table or table correlation name.
SELECT
LastName + ", " + FirstName AS e."Full Name",
Salary AS Wage
FROM
Employee e;
The prefixing table or table correlation name for secondary columns is indifferent as long as the prefix used is included in the FROM clause. This is also true for output columns created as results combined from distinct tables as in JOIN selects.
Supplementary notes on LocalSQL added by Niels Knabe
