[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.Name,

[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