The following query returns all 8 prayer request categories with the total #
of requests every submitted to each category:
SELECT `prayer_request_category`.`reference` ,
`prayer_request_category`.`category` , COUNT(
`prayer_requests`.`reference` ) AS category_request_count
FROM `prayer_request_category`
LEFT OUTER JOIN `prayer_requests` ON `prayer_request_category`.`reference` =
`prayer_requests`.`prayer_request_category_reference`
GROUP BY `prayer_request_category`.`reference`
ORDER BY `prayer_request_category`.`category` ASC
I would like to add the following 2 WHERE conditions to this query so only
the live prayer requests are included in the COUNT:
`prayer_requests`.`approval_level` IN ( 1, 3 )
`prayer_requests`.`prayer_request_type` = 1
When I do this only the categories with live prayer requests are returned,
instead of all 8 categories. Is there a way to build these WHERE conditions
which will still allow all 8 categories to be included in the result?
Thank you,
Ron
The Verse of the Day
âEncouragement from Godâs Wordâ
http://www.TheVerseOfTheDay.info
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
