你好,我有一个查询,我必须在其中应用并在连接位置设置条件,但我不知道如何在zend中做到这一点。请帮忙。
$dbA = $this->dbAdapter;
$sql = new Sql($dbA);
$select = $sql->select()->from(array('answer' => 'tblanswer'));
$select->columns($fetch);
$select->join(array('fixed' => 'tblfixanswer'), 'fixed.aid = answer.aid', array(), 'left');
$selectString = $sql->getSqlStringForSqlObject($select);
$results = $dbA->query($selectString, $dbA::QUERY_MODE_EXECUTE);
所需输出为:
SELECT *
FROM `tblanswer` AS `answer`
LEFT JOIN `tblfixanswer` AS `fixed` ON `fixed`.`aid` = `answer`.`aid` and fixed.baid=27
值27来自一个变量。
你可以很容易地做到这一点,
dbA = $this->dbAdapter;
$sql = new Sql($dbA);
$select = $sql->select()->from(array('answer' => 'tblanswer'));
$select->columns($fetch);
$select->join(array('fixed' => 'tblfixanswer'), 'fixed.aid = answer.aid AND fixed.baid=27', array(), 'left');
$selectString = $sql->getSqlStringForSqlObject($select);
$results = $dbA->query($selectString, $dbA::QUERY_MODE_EXECUTE);
希望能有所帮助。。