看起来你正试图加入两张桌子 —— & gt; join, 我认为你做不到 。
从 Zend_ Db_ select () 加入代码
/**
* Adds a JOIN table and columns to the query.
*
* The $name and $cols parameters follow the same logic
* as described in the from() method.
*
* @param array|string|Zend_Db_Expr $name The table name.
* @param string $cond Join on this condition.
* @param array|string $cols The columns to select from the joined table.
* @param string $schema The database name to specify, if any.
* @return Zend_Db_Select This Zend_Db_Select object.
*/
public function join($name, $cond, $cols = self::SQL_WILDCARD, $schema = null)
{
return $this->joinInner($name, $cond, $cols, $schema);
}
这里是从 () 到 () 的批注块
/**
* Adds a FROM table and optional columns to the query.
*
* The first parameter $name can be a simple string, in which case the
* correlation name is generated automatically. If you want to specify
* the correlation name, the first parameter must be an associative
* array in which the key is the correlation name, and the value is
* the physical table name. For example, array( alias => table ).
* The correlation name is prepended to all columns fetched for this
* table.
*
* The second parameter can be a single string or Zend_Db_Expr object,
* or else an array of strings or Zend_Db_Expr objects.
*
* The first parameter can be null or an empty string, in which case
* no correlation name is generated or prepended to the columns named
* in the second parameter.
*
* @param array|string|Zend_Db_Expr $name The table name or an associative array
* relating correlation name to table name.
* @param array|string|Zend_Db_Expr $cols The columns to select from this table.
* @param string $schema The schema name to specify, if any.
* @return Zend_Db_Select This Zend_Db_Select object.
*/
不如试试这个吧
$select = $this->_db->select()
//FROM table procurement_tbltenderevaluationcriteria AS evaluationcriteria, SELECT FROM
//COLUMNS ScoringCriteriaID and ScoringCriteriaWeight
->from(array( evaluationcriteria => procurement_tbltenderevaluationcriteria ),
array( ScoringCriteriaID , ScoringCriteriaWeight ))
//JOIN TABLE procurement_tbltenderscoringcriteria AS scoringcriteria WHERE
//TenderId FROM TABLE scoringcriteria == TenderId FROM TABLE evaluationcriteria
->join(array( scoringcriteria => procurement_tbltenderscoringcriteria ),
scoringcriteria.TenderId=evaluationcriteria.TenderId )
//JOIN TABLE procurement_tbltenderapplications AS tenderapplications
->join(array( tenderapplications => procurement_tbltenderapplications ))
//JOIN TABLE tblsupplier AS tendersupplier WHERE TenderInvitationContractorID FROM TABLE
// tenderapplications == UserID FROM TABLE tendersupplier
->join(array( tendersupplier => tblsupplier ),
tenderapplications.TenderInvitationContractorID=tendersupplier.UserID );
"http://framework.zend.com/manual/en/zend.db.table.html#zed.db.table.advanced.usage.sage" rel="no follow" 可能还需要修改您选择的定义,允许加入 :
//this will lock the tables to prevent data corruption
$this->_db->select(Zend_Db_Table::SELECT_WITHOUT_FROM_PART)->setIntegrityCheck(FALSE);
我希望我能正确读懂你的用意, 这应该能让你更接近,如果不是一路走近的话。 (一个提示,用简短的别名... )
