Ok let's say the field anotherfield is one the field (in table address) you
didn't talk about in the first post.
This should work even if you have more fields.
SELECT
T6.personuid,
T7.ADDRESSTEXT,
T7.anotherfield
FROM
(
SELECT
T5.personuid,
MAX(T4.addressuid) maxadUID
FROM
(
SELECT
personuid, MAX(validitystartdate) maxdate
FROM
person2Address t1, Address t2
WHERE
t1.addressuid = t2.addressuid
GROUP BY personuid
) T3,
address T4,
Person2Address T5
WHERE
T4.addressuid = T5.addressuid
AND
T4.validitystartdate = T3.maxdate
GROUP BY
T5.personuid
) T6,
Address T7
WHERE
T7.addressuid = T6.maxadUID
Received on Wed Jan 05 2005 - 07:57:24 CST
