Sorry to reply twice, I forgot something :)
On 23. Sep 2008, at 23:26, Bill Karwin wrote:
Another option might be to use a derived table in a full subquery
AFAIK, MySQL, which is what I use, will always materialize subqueries
in FROM, which is not something I want.
The hackish solution I've used currently is:
My_Db_Select:
--
protected function _getQuotedTable($tableName, $correlationName =
null)
{
$correlationName = is_object($tableName) && @$tableName-
>noAutoCorrelationName ? null : $correlationName;
return parent::_getQuotedTable($tableName, $correlationName);
}
--
And then I set $expr->noAutoCorrelation=true on the Zend_Db_Expr when
passing it to join();
Jaka
