Re: SQL Question

Try somethin like this:

SELECT A.START_DATE
, max(B.START_DATE)
FROM
ENCOUNTERS A,
ENCOUNTERS B,
EXT_PAT_IDS C,
PATIENT_DEMO D
# join A -> B

WHERE A.START_DATE > B.START_DATE (+)
AND A.PAT_ID = B.PAT_ID (+)
# join A - D

AND A.PAT_ID = D.PAT_ID
# join D - C

AND D.PAT_ID=C.PAT_ID
# criteria for C

AND C.EXT_PAT_ID_TYPE = 2
AND C.EXT_PAT_ID = '01216116'
# GROUP

GROUP BY A.START_DATE

--
Posted via http://dbforums.com