On Wed, Mar 9, 2011 at 3:14 PM, gelform <[email protected]> wrote: > I can't figure out how to set multiple from's.
You can only have one FROM in a SQL query. To join another table, use $select->join($tableName, $arrayOfFields) or $select->join(array($alias => $tableName), $arrayOfFields). The join() method will use an INNER JOIN, but if you need a LEFT JOIN use the joinLeft() method. For more info you might want to read up on the documentation: http://framework.zend.com/manual/en/zend.db.select.html -- *Hector Virgen* Sr. Web Developer http://www.virgentech.com
