![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
![]() |
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 Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |