correct, I tried to use
your convention, but I may have missed something.
Robert V. Zwink
http://www.zwink.net/daid.php
-Original Message-
From: Michael Robbins [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 4:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help with a JOIN statemen
I have 2 tables, 'users' and 'files' (defined below)
Can I construct a single SELECT statement so that it will return ONLY
users that have files and ONLY the last file that the user has? So it
would return 1 row per user containing their most recent file.
users
Id int
Name