Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
SELECT Distinct AVP.ID, PER.PersonID, 1, 1 FROM PERSON P Cross JOIN C6..PERSON_SUBSET PER WHERE P.Forename <> '' AND P.Surname <> '' And (P.Forename = PER.EnglishForename Or PER.PERSONID in ( Select PersonID From C6..Person_Subset Where EnglishForename In (Select Name_Variation from Names_Database..Forename Where [Source_Name] = P.Forename and Score >= 95))) AND (P.Surname = PER.EnglishSurname OR PER.PERSONID in ( Select PersonID From C6..Person_Subset Where EnglishSurname in (Select Name_Variation from Names_Database..Surname Where [Source_Name] = P.Surname and Score >= 95)))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.