Re: Select with join query question

[Bruce Feist]

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]