Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: John Hay Reported On: 3/17/2010 For: Version 2.03 Build 9 |
SELECT DISTINCT c._id,_fkContacts,_Surname, _Forename,_fkCompanies,_fkSites FROM Career C JOIN Contacts C1 ON C._fkContacts=Contacts._ID JOIN (SELECT _Surname, _Forename,_fkCompanies,_fkSites,count(*) as cnt FROM Career JOIN Contacts C ON _fkContacts = C._ID GROUP BY _Surname, _Forename,_fkCompanies,_fkSites HAVING cnt > 1) t1 ON C1._Surname=t1._Surname AND C1._Forename= t1._Forename AND C._fkCompanies=t1._fkCompanies AND C._fkSites=t1._fkSites order by _surname,_forename
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 |