Re: [fw-general] Problem with Zend_Db_Select and sub-query as join

[Bjarte Kalstveit Vebjørnsen]

OK,  thanks for clearing that up. I will rewrite it as a string, it's 
just a few queries anyway.
Thanks!

Regards,
Bjarte
Bill Karwin skrev:
Hmm, that should not be the case.  If it is, then it's a bug and we'll fix it.

In the meantime, you don't have to use Zend_Db_Select.  You could just write 
out the whole SQL query as a string, including the subquery.  There are other 
cases of complex SQL syntax that is not supported by Zend_Db_Select (such as 
UNION).

Regards,
Bill Karwin