Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Richard Harding Reported On: 12/3/2009 For: Version 2.03 Build 6 |
Wrong: SELECT ID, FName, MName, LName FROM Contacts C1 WHERE C1.FName ||C1.MName || C1.LName IN (SELECT C2.FName ||C2.MName || C2.LName FROM Contacts C2 GROUP BY FName, MName, LName HAVING COUNT(*) > 1) ID, FName, MName, LName 2 | Mary | A | Doe | 4 | Mary | A | Doe | Correct: SELECT DISTINCT ID, FName, MName, LName FROM Contacts C1 WHERE C1.FName ||C1.MName || C1.LName IN (SELECT C2.FName ||C2.MName || C2.LName FROM Contacts C2 GROUP BY FName, MName, LName HAVING COUNT(*) > 1) ID, FName, MName, LName 1 | John | W | Doe | JR 6 | John | W | Doe | JR 2 | Mary | A | Doe | 4 | Mary | A | Doe |
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |