maybe you're looking 4 something like this:
select user , filename , count(filename)
from table
group by user,filename
having count(filename) = 3
order by 1,2;
Rui
Tristan.Pretty@xxxxxxxxxxxxxxxx writes:
Hi there...
I'm trying to create a MYSQL query that does the following...
I've a table that lists ALL downloads from our site.
so I may have the same user many times, but different files, or infact, same user, same file.
What my boss wants to see is:
If a user downloaded a file 3 times, she doesn't care, she just wants to see that it was downloaded.
So I tried using DISTINCT(email), but then I loose the data about the other files that they've downloaded
How can I create a query, where I can list only one instance of email, per multiple instatnces of a file name.
Does that make sence?
I'm reallyu stumped...
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
