zend-framework - 禅德数据库 : joinLeft problem

Question

我正在尝试使用 Zend DB 构建此查询:

SELECT
    `s` . * ,
    `a` . *
FROM 
    `shr_statement` AS  `s`
LEFT JOIN  
    `shr_answer` AS a`
ON 
    a.statement_id = s.statement_id 
    AND
    a.user_id =1
WHERE
    (s.language =  'en_US') AND (s.is_active =1 )
ORDER BY 
    `order` ASC

我读到有关双“ON”语句可能存在的问题...

谢谢!

Answer 1

这应该可以解决问题，其中 $db 是 Zend_Db 适配器的实例

$select = $db->select()
    ->from(array('s' => 'shr_statement'))
    ->joinLeft(array('a' => 'shr_answer'), 'a.statement_id = s.statement_id')
    ->where('s.language = ?', 'en_US')
    ->where('s.is_active = ?', 1)
    ->where('a.user_id = ?', 1)