Not that I'm aware of, but....
Why do you have to use Zend_Db_Select to do this??
If it's a static query like that, that isn't built procedurally, there's nothing wrong with just
using the SQL statement.
On 18/02/2009 10:31 AM, Henry Umansky wrote:
Is there an easy way to run the following query using Zend_Db_Select
without using joins?
SELECT
(SELECT Count(*) FROM articles WHERE status=0) AS 'Draft',
(SELECT Count(*) FROM articles WHERE status=1) AS 'Review',
(SELECT Count(*) FROM articles WHERE status=2) AS 'Published'
I just need to get the count according to the record status.
-Henry
