On Thu, 5 Jul 2001, Jeff Lewis wrote:

> owners
> -ownerID
> -teamname
> -more fields
> teampages
> -ownerID
> -bio
> Anyway, I'm doing a select on the database like this: select ownerID,
> last_update FROM teampages ORDER BY last_update DESC LIMIT 10
> The thing is, I want to get the team name from the other table as well.  Can
> anyone help me out?

SELECT owners.ownerID, ??.last_update
FROM owners, teampages
WHERE owners.ownerID = teampages.ownerID
ORDER BY last_update DESC  LIMIT 10

_should_ work.


Sapere aude
My mind not only wanders, it sometimes leaves completely.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to