Re: PHP/mySQL Query
| From: | Duncan Hill | Date: | Fri, 06 Jul 2001 00:21:51 +0000 |
| Subject: | Re: PHP/mySQL Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56408@lists.php.net to get a copy of this message | ||
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.