| Operation Details |  |
| Description: | retrieves a list of contact email addresses for a contact. |
| Sterotype: | nsmulti |
| SQL | |
SELECT typeCode, emailAddress, startDate, endDate, statusCode, contactEmailAddressID, EmailAddress.emailAddressID, EmailAddress.versionNo, ContactEmailAddress.versionNo INTO :typeCode, :emailAddress, :startDate, :endDate, :statusCode, :contactEmailAddressID, :emailAddressID, :emailAddressVersionNo, :contactEmailAddressVersionNo FROM EmailAddress, ContactEmailAddress WHERE contactID = :contactID AND EmailAddress.emailAddressID = ContactEmailAddress.emailAddressID |