SELECT
  Person.personBirthName,
  Person.dateOfBirth,
  Person.dateOfDeath,
  Person.gender,
  Person.specialInterestCode,
  Person.maritalStatusCode,
  Person.nationalityCode,
  Person.motherBirthSurname,
  Person.comments,
  Person.dateOfBirthVerInd,
  Person.dateOfDeathVerInd,
  Person.countryOfBirth,
  Person.placeOfBirth,
  Person.ethnicOriginCode,
  Person.paymentFrequency,
  Person.nextPaymentDate,
  Person.currencyType,
  Person.methodOfPmtCode,
  Person.race,
  Person.indigenousGroupCode,
  ConcernRole.primaryAlternateID,
  ConcernRole.registrationDate,
  ConcernRole.statusCode,
  ConcernRole.prefPublicOfficeID,
  ConcernRole.preferredLanguage,
  ConcernRole.sensitivity,
  ConcernRole.prefCommMethod,
  ConcernRole.prefCommFromDate,
  ConcernRole.prefCommToDate,
  ConcernRole.primaryAddressID,
  ConcernRole.primaryPhoneNumberID,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleType,
  AlternateName.title,
  AlternateName.firstForename,
  AlternateName.otherForename,
  AlternateName.surname,
  AlternateName.nameSuffix,
  AlternateName.initials
INTO
  :birthName,
  :dateOfBirth,
  :dateOfDeath,
  :sex,
  :specialInterest,
  :maritalStatus,
  :nationality,
  :motherBirthSurname,
  :remarks,
  :dateOfBirthVerified,
  :dateOfDeathVerified,
  :birthCountry,
  :birthPlace,
  :ethnicOriginCode,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :race,
  :indigenousGroupCode,
  :primaryAlternateID,
  :registrationDate,
  :statusCode,
  :preferredPublicOfficeID,
  :preferredLanguage,
  :sensitivity,
  :prefCommMethod,
  :prefCommFromDate,
  :prefCommToDate,
  :primaryAddressID,
  :primaryPhoneNumberID,
  :fullName,
  :concernRoleType,
  :title,
  :firstForename,
  :otherForename,
  :surname,
  :nameSuffix,
  :initials 
FROM
  Person,
  ConcernRole,
  AlternateName 
WHERE Person.concernRoleID = :concernRoleID 
  AND ConcernRole.concernRoleID = :concernRoleID 
  AND AlternateName.alternateNameID = Person.primaryAlternateNameID