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