Zend 框架:Zend_Db_Select - 如何加入自定义子查询表? [英] Zend Framework: Zend_Db_Select - how to join custom subquery table?

问题描述

$select->joinRight(array('i' => '(SELECT * FROM images ORDER BY image_id)'),'i.ad_id = '. $main .'.id',$imarray);

这样是行不通的.子查询获取引号.

Like that doesn't work. Subquery getting inside quotes.

像这样:

RIGHT JOIN `(SELECT * FROM images ORDER BY image_id)` AS `i` ON i.ad_id = a.id

谢谢;)

推荐答案

使用

$select->joinRight(
    array('i' => new Zend_Db_Expr('(SELECT * FROM images ORDER BY image_id)')),
    'i.ad_id = '. $main .'.id',
    $imarray
);

这篇关于Zend 框架:Zend_Db_Select - 如何加入自定义子查询表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！