Select the last memo

  • Thread starter Thread starter Tarek
  • Start date Start date
T

Tarek

Hello!

how can I select the last (in terms of date) memo of a table? for each
customer.
the table content looks like:
id | myDate | myMemo
---------------------------
1 01.02.04 Text1
1 01.04.03 Text2
2 02.03.02 Text3
2 02.01.04 Text3

I have tried this query but it returns only the last memo of the hole
table..

SELECT id, DateMemo, myMemo
FROM myTable
WHERE DateMemo=(SELECT Max(DateMemo) FROM myTable)
GROUP BY id, DateMemo, myMemo

Thanks!
 
Great Thanks!
here is the answer for who is intersted:
______________________________________________
SELECT Q.ID, Q.myMemo, Q.DateMemo
FROM myTable As Q INNER JOIN myTable As T
ON Q.ID=T.ID
GROUP BY Q.ID, Q.DateMemo, Q.myMemo
HAVING Q.DateMemo = Max(T.DateMemo)
______________________________________________
Best regards
 
Back
Top