SELECT
AlternateName.firstForename,
AlternateName.surname,
Person.dateOfBirth,
Person.gender,
Person.personBirthName,
Person.motherBirthSurname,
Person.primaryAlternateID,
Person.concernRoleID,
ConcernRole.sensitivity,
city.elementValue,
addressLine1.elementValue
INTO
:firstForename,
:surname,
:dateOfBirth,
:gender,
:personBirthName,
:motherBirthSurname,
:primaryAlternateID,
:concernRoleID,
:sensitivity,
:city,
:addressLine1
FROM
Person,
ConcernRole,
AlternateName,
AddressElement city,
AddressElement addressLine1
WHERE Person.concernRoleID = ConcernRole.concernRoleID
AND Person.primaryAlternateNameID = AlternateName.alternateNameID
AND
(
city.addressID = ConcernRole.primaryAddressID
AND city.elementType = :cityType
)
AND
(
addressLine1.addressID = ConcernRole.primaryAddressID
AND addressLine1.elementType = :addressLine1Type
)
|