Operation Details |
Description: | Populate all the records by contactID |
Sterotype: | nsmulti |
SQL |
SELECT typeCode, addressData, startDate, endDate, ContactAddress.statusCode, contactAddressID, Address.addressID, Address.versionNo, ContactAddress.versionNo INTO :typeCode, :addressData, :startDate, :endDate, :statusCode, :contactAddressID, :addressID, :addressVersionNo, :contactAddressVersionNo FROM Address, ContactAddress WHERE ContactAddress.contactID = :contactID AND Address.addressID = ContactAddress.addressID |