DISTINCT Query Problems

[jtown]

I'm trying to retrieve the most recently touched entries in a table using this SQL.

SELECT DISTINCT USERS.username AS uname FROM USERS, HITS WHERE USERS.userid = HITS.userid AND HITS.userid > 0 ORDER BY HITS.lasthit DESC LIMIT 5

But it's acting weird and not showing what I think it would show. lasthit is a datetime field. I'm using the limit because I only want the last 5 people and there are some entries where the userid is 0 that I want to filter out. Any help?

My current results skip some entries that should be queried for some reason.

Thanks.

[Drakla]

Can you give more details on the entries that are being skipped, as the query looks fine, the only 'mistake' I could imagine is if you wanted to hits hits to the same person's site, and of course the distinct name is exactly there to stop that..

[jtown]

It just completely misses maybe 2 out of 5 entries that should be listed. When I take out distinct I see the proper 5 recent entries. When I add it, it gets rid of the duplicates, but it also misses some of the entries .... for instance the most recent hit.