如何在Zend Framework中使用子查询执行查询 [英] How execute query with subqueries in zend framework

问题描述

我需要用Zend_Db_Select编写此sql，但是我不知道如何编写子查询.我将不胜感激任何帮助.谢谢.

Hi I need write this sql with Zend_Db_Select, but I dont know how I can write subqueries. I would appreciate any help. Thanks.

SELECT * FROM advert WHERE categoryId
           IN (
             SELECT id
              FROM `tree`
              WHERE `lft` BETWEEN 
               (SELECT lft FROM tree WHERE id = '2') AND 
               (SELECT rgt FROM tree WHERE id = '2'))

推荐答案

// create the main query
$select = new Zend_Db_Select();

//create the subquery
$subSelect = new Zend_Db_Select();

// using the subquery in main query
$select->where('table.field IN(?)', $subSelect->assemble());

这篇关于如何在Zend Framework中使用子查询执行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！