Icon View Incident Report

Serious Serious
Reported By: Herbert Sitz
Reported On: 2/10/2004
For: Version 4.02 Build 1
# 1542 TOP N SELECT Queries Improperly Returning Distinct Results

The query below is not generating the correct results. Specifically, the surname 'Wells' only appears one although there are two such records in the table.

Select CustNo, Last_Name, First_Name from Custoly Order By Last_Name 
DESC 
Top 10;



Resolution Resolution
Fixed Problem on 2/11/2004 in version 4.03 build 1
Image