Re: Query explanation
| From: | Robb Kerr | Date: | Wed, 29 Oct 2003 16:47:12 +0000 |
| Subject: | Re: Query explanation | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168021@lists.php.net to get a copy of this message | ||
On Wed, 29 Oct 2003 17:31:26 +0100, Alexander Mueller wrote:
>
> Exactly. "a" and "s" are referring to the two tables and are assigned in
> the FROM clause. You could write the query also without the
> abbreviations.
>
> SELECT state.ID, state.Name, areacode.Code FROM areacode, state
> WHERE areacode.State = state.ID
> ORDER BY state.Name, areacode.Code
>
> Alexander
Thanx. It looks like I'm actually learning this stuff. hehe
--
Robb Kerr
Digital IGUANA