Hi!
I'd like to do the following:
$select->joinLeft(new Zend_Db_Expr("(someTable t1 JOIN someOtherTable
t2 ON t2.id = t1.id)"), "t2.foo = outer.foo");
This olmost works as expected, the only problem is that an
automatically generated correlation name (e.g. "AS t1") will get
appended to the join, which will make it invalid SQL.
Is there a way to avoid this?
Is there another way to create nested joins?
I would not like to resort to manually stiching together SQL strings,
since the query is generated dynamically.
Regards,
Jaka
