Reported By: Herbert Sitz Reported On: 2/10/2004 For: Version 4.02 Build 1
# 1542TOP 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;
ResolutionFixed Problem on 2/11/2004 in version 4.03 build 1