Re: SQL Troubles with JOIN, GROUP BY and MAX???
| From: | Adam Royle | Date: | Tue, 04 Jun 2002 09:36:19 +0000 |
| Subject: | Re: SQL Troubles with JOIN, GROUP BY and MAX??? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19595@lists.php.net to get a copy of this message | ||
I think this is something like you would want...
Adam
SELECT users.id, username, MAX(stamp) as stamp, filename
FROM users, files
WHERE users.id = userid
GROUP BY username