Richard Bolen wrote:

This works! I was then wondering how to get the total number of all
jobs that this condition is true for?


Just include count(distinct j.jobid) in the SELECT list.

Bruce

select j.*
FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /* all selected columns */ HAVING min(abs(s.status - 1)) > 0






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to