Icon View Incident Report

Minor Minor
Reported By: David Cornelius
Reported On: 9/19/2008
For: Version 2.01 Build 5
# 2804 Using an ORDER BY with a UNION/EXCEPT/INTERSECT Query and a Column Correlation Name Causes Error

I have the following UNION statement, which works fine. But the resulting data set is not sorted by CustName. All the like
CustNames are together, but not alphabetically. So I should be able to add an ORDER BY clause at the end of it all.


This, however, does NOT work. I get error 401, CustName does not exist.

 SELECT CustCompany AS CustName, Total
 FROM Orders
 SELECT CompanyName AS CustName, Total
 FROM Invoices
 GROUP BY CustName

Resolution Resolution
Fixed Problem on 9/20/2008 in version 2.02 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial