[PHP] Re: Query explanation

2003-10-29 Thread Robb Kerr
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 are

[PHP] Re: Query explanation

2003-10-29 Thread Alexander Mueller
Robb Kerr wrote: > > I am attempting to hack a tutorial from the Zend site. I have found the > tutorial/project to be excellent, but I don't completely understand what's > being done in the following Query statement. > > //query database, assemble data for selectors > $Query = "SELECT s.ID, s