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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php