Not all databases support implicit joins, so you need to convert it to
explicit joins.
So instead of:
SELECT parent.name
FROM nested_category AS node,
nested_category AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.name = 'FLASH'
ORDER BY parent.lft;
You'd have:
SELECT parent.
Very cool, David. Thanks!
On Wed, Mar 9, 2011 at 7:57 PM, David Muir [via Zend Framework
Community] wrote:
> Not all databases support implicit joins, so you need to convert it to
> explicit joins.
> So instead of:
> SELECT parent.name
> FROM nested_category AS node,
> nested_category AS parent
>
On Wed, Mar 9, 2011 at 4:30 PM, gelform wrote:
> i guess I have to use raw sql.
What is the resulting SQL you are trying to achieve? Most likely
Zend_Db_Select can be used to generate it.
--
*Hector Virgen*
Sr. Web Developer
http://www.virgentech.com
Okay, thanks. I looked thru the documentation, but didn't see a solution to
what I needed. That's why I asked. :-)
i guess I have to use raw sql.
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/Zend-Db-Select-with-multiple-from-s-tp3344822p3344923.html
Sent
