group by get last record
| From: | Daniel Harik | Date: | Sun, 16 Mar 2003 08:02:02 +0000 |
| Subject: | group by get last record | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-26405@lists.php.net to get a copy of this message | ||
Hello,
Guys i try to join to tables
slides:
id
userid
file
moment
users
id
username
As there few slids per user and i want to get only last one, i use following
sql query, but it fetches me first slide. How can i make it fetch last one
please?
SELECT slides.file, slides.moment, users.id, users.username FROM slides,
users where users.id=slides.userid GROUP BY users.id desc