At 04/06/2002 08:58, Evgeny Chuykov wrote:
>Try something like this:
>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 :(
Tel : +33 5 53 88 00 76
Fax : +33 5 53 88 01 16
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php