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.name
FROM nested_category AS node
JOIN nested_category AS parent ON (node.lft BETWEEN parent.lft AND
parent.rgt)
WHERE node.name = 'FLASH'
ORDER BY parent.lft;
Which is quite straight forward to convert to Zend_Db_Select:
$select = $db->select();
$select->from(array('node' => 'nested_category'), array('parent.name'))
->join(array('parent' => 'nested_category'), 'node.lft BETWEEN
parent.lft AND parent.rgt')
->where('name.name=?', 'FLASH')
->order('parent.lft');
Cheers,
David
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/Zend-Db-Select-with-multiple-from-s-tp3344822p3344961.html
Sent from the Zend Framework mailing list archive at Nabble.com.
