SELECT
ConcernRole.concernRoleName,
ConcernRole.primaryAlternateID,
ProductProvider.registeredName,
Address.addressData,
WebAddress.webAddress,
PhoneNumber.phoneNumberID,
EmailAddress.emailAddress
INTO
:name,
:primaryAlternateID,
:registeredName,
:addressData,
:webAddress,
:phoneNumberID,
:emailAddress
FROM
ConcernRole
LEFT OUTER JOIN
ProductProvider
ON (ConcernRole.concernRoleID = ProductProvider.concernRoleID)
LEFT OUTER JOIN
Address
ON (ConcernRole.primaryAddressID = Address.addressID)
LEFT OUTER JOIN
WebAddress
ON (ConcernRole.primaryWebAddressID = WebAddress.webAddressID)
LEFT OUTER JOIN
PhoneNumber
ON (ConcernRole.primaryPhoneNumberID = PhoneNumber.phoneNumberID)
LEFT OUTER JOIN
EmailAddress
ON (ConcernRole.primaryEmailAddressID = EmailAddress.emailAddressID)
WHERE ConcernRole.concernRoleID = :concernRoleID
|