Re: Re: SQL Troubles with JOIN, GROUP BY and MAX???

At 04/06/2002 08:58, Evgeny Chuykov wrote:

Try something like this: SELECT USERS.Username,FILES.Filename FROM USERS LEFT JOIN FILES USING(Id) WHERE FILES.Filename IS NOT NULL ORDER BY FILES.Stamp DESC LIMIT 1;

I think it's wrong because Id isn't the matching column in 'FILES'. 2nd line should be 'FROM USERS LEFT JOIN FILES ON FILES.Userid = USER.Id' And 'LIMIT 1' return 1 line not the first line for each USER. I encounter such problem but I'm affraid that I didn't solve it :( -- Hubert ADGIE hubert.adgie@ispinfo.fr Tel : +33 5 53 88 00 76 Fax : +33 5 53 88 01 16