Operation Details |
Description: | |
Sterotype: | ns |
SQL |
SELECT concernRoleName, gender, dateOfBirth, Person.primaryAlternateID, primaryAddressID, primaryPhoneNumberID INTO :concernRoleName, :gender, :dateOfBirth, :primaryAlternateID, :primaryAddressID, :primaryPhoneNumberID FROM ConcernRole, Person WHERE ConcernRole.concernRoleID = :participantID AND Person.concernRoleID = ConcernRole.concernRoleID AND Person.primaryAlternateID = ConcernRole.primaryAlternateID |