Max Date

[pgh2377]

I have a table that stores a patients notes per date. For example, one patient may have 4 different notes(memo's) for four dates. Connecting to other tables, I'm trying to pull the last date so I can get the last memo. However each time I do it all the dates and memo's appear. I've tried max date but it does not work. Any suggestions?

 

[lespaul]

Something like this:

SELECT P.PATIENTID, M.NOTES, M.MemoDATE
FROM PatientTable As P
INNER JOIN MemoTable As M on M.PatientID = P.PatientID where M.MemoDate = (SELECT MAX(MemoDate) FROM MemoTable M2 Where P.PatientID = M2.PatientID)

Leslie

 

[pgh2377]

pulls all 4

 

[lespaul]

What is the SQL for query you are using?

Leslie

 

[OhioSteve]

Perhaps you could list your tables, their fields, the fields' data types. Then tell us specifically what you want to achieve. Once we have enough information, it should be easy to construct an sql.