Database SQL Operation: ConcernRoleAlternateID.searchPersonDetailsByAltID
| Description: | Method that retrieves detail of a person with a given alternateID |
| Sterotype: | nsmulti |
select concernrolealternateid.concernroleid, concernrole.concernrolename,concernrole.concernroletype,
person.dateofbirth, address.addressdata
INTO :concernRoleID, :concernRoleName, :concernRoleType, :dateOfBirth, :addressData
FROM concernrolealternateid
INNER JOIN concernrole ON concernrole.concernroleid=concernrolealternateid.concernroleid
INNER JOIN person ON person.concernroleid=concernrolealternateid.concernroleid
INNER JOIN address ON concernrole.primaryaddressid=address.addressid
WHERE concernrolealternateid.alternateid=:alternateID
|
