php - How to create Zend_Db_Select with nested queries? -

I do not know if this is possible, but I want to make it a Zend_Db_Select object and I do not know how

  SELECT * MyTable MT1 to WHERE MT1.date = (Choose from MyTable MT2 MAX (MT2.date))  

Perhaps something like this will happen:

  $ nested suspect = $ db- & gt; Select () - & gt; From (array ('MT2' = & gt; 'MyTable'), New Zend_Db_Expr ('MAX2 (MT2.date)')); $ ($ '$', 'MyTable')) - & gt; Select ('MT1.date =?', New Zend_Db_Expr ('('. $ NestedSelect- & gt; toString (). ')'));