SELECT
   Person.concernRoleID, 
   Person.personBirthName,   
   Person.dateOfBirth,   
   Person.dateOfDeath,   
   Person.gender,   
   Person.specialInterestCode,   
   Person.maritalStatusCode,   
   Person.nationalityCode,   
   Person.motherBirthSurname,   
   Person.dateOfBirthVerInd,   
   Person.dateOfDeathVerInd,
   Person.countryOfBirth,
   Person.placeOfBirth,
   Person.ethnicOriginCode,
   Person.paymentFrequency,
   Person.nextPaymentDate,
   Person.currencyType,
   Person.methodOfPmtCode,
   Person.race,
   Person.indigenousPersonInd,
   Person.indigenousGroupCode,
   Person.residencyAbroadInd,
   Person.versionNo,
   AlternateName.title,
   AlternateName.firstForename,
   AlternateName.otherForename,
   AlternateName.surname,
   AlternateName.nameSuffix,
   AlternateName.initials 
INTO
   :concernRoleID,
   :personBirthName,
   :dateOfBirth,
   :dateOfDeath,
   :gender,
   :specialInterestCode,
   :maritalStatusCode,
   :nationalityCode,
   :motherBirthSurname,
   :dateOfBirthVerInd,
   :dateOfDeathVerInd,
   :countryOfBirth,
   :placeOfBirth,
   :ethnicOriginCode,
   :paymentFrequency,
   :nextPaymentDate,
   :currencyType,
   :methodOfPmtCode,
   :race,
   :indigenousPersonInd,
   :indigenousGroupCode,
   :residencyAbroadInd,
   :versionNo,
   :title,
   :firstForename,
   :otherForename,
   :surname,
   :nameSuffix,
   :initials  
FROM   
   Person, AlternateName  
WHERE 
Person.concernRoleID = :concernRoleID
AND AlternateName.alternateNameID = Person.primaryAlternateNameID