SELECT pa1.person_id, pa1.address_type, pa1.address_id, pa2.address_id, pa2.date_from FROM per_addresses pa1, per_addresses pa2 WHERE pa1.person_id = pa2.person_id AND pa1.date_to = pa2.date_from - 1 AND pa1.address_type = pa2.address_type
SELECT PA1.PERSON_ID
, PA1.ADDRESS_TYPE
, PA1.ADDRESS_ID
, PA2.ADDRESS_ID
, PA2.DATE_FROM
FROM PER_ADDRESSES PA1
, PER_ADDRESSES PA2
WHERE PA1.PERSON_ID = PA2.PERSON_ID
AND PA1.DATE_TO = PA2.DATE_FROM - 1
AND PA1.ADDRESS_TYPE = PA2.ADDRESS_TYPE
|
|
|