Recent Docment List

Hi Everyone,

I was hoping someone could give me a clue as to how to do something like the following:

Select Distinct TOP 5 CaseId From Dna..CaseLog
Where Username = 'SomeUser' Order By LogDate Desc


This gives me an error:


ORDER BY items must appear in the select list if SELECT DISTINCT is specified.


As you can probably see, I am trying to get a list of the last five cases that a particular user accessed, similar to a recent document list, in say Word.

The CaseLog table, however, keeps a record of all the updates to this case. So if I open a particular case twice, it will log that I opened it twice, with the same CaseId but with LogDate slighly different (ie by seconds).

Is there anyway I can get what I am looking for without having to have another log to keep track of what user has access what case?

Thanks very much for any help


Shai