Re: please help me in building a SQL query...........

Hi,

There may be something faster & easier but i'm too lazy to search for it ;p

SELECT
 T5.personuid,
 MAX(addresstext)
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 Received on Wed Jan 05 2005 - 02:54:50 CST