How to create Zend_Db_Select with nested queries?

Question

I don't know if its possible but I'd like to make it a Zend_Db_Select object and I don't know how

SELECT *
FROM MyTable MT1
WHERE MT1.date = (
     SELECT MAX(MT2.date)
     FROM MyTable MT2
)

Community · Accepted Answer · 2013-02-28 14:18:01Z

2

Maybe something like that would work :

$nestedSelect = $db->select()->from(
    array('MT2' => 'MyTable'),
    new Zend_Db_Expr('MAX(MT2.date)')
);

$select = $db->select()->from(
    array('MT1', 'MyTable')
)->where(
    'MT1.date = ?', new Zend_Db_Expr('(' . $nestedSelect->toString() . ')')
);

edited Feb 28, 2013 at 14:18

CommunityBot

11 silver badge

answered May 16, 2010 at 10:10

Boris Guéry

47.6k8 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:43:06Z

0

You may also do it by simply replacing the ($this->select()) subquery variable in the main query (more: https://stackoverflow.com/a/1341463/216084)

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Dec 21, 2012 at 7:14

user216084

Collectives™ on Stack Overflow

How to create Zend_Db_Select with nested queries?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related