Get count on all rows

Databases
1

Hi Guys!

The following query returns the number of jobs listed in each industry. However, it will only return rows that have a count bigger than 0. Is there a way I can return all rows including rows which have 0 count?


SELECT industries . * , count( jobs.id ) AS count
FROM industries
LEFT JOIN jobs ON jobs.industry = industries.id
where jobs.status='on'
GROUP BY industries.id
ORDER BY industries.industry

Thanks in advance.

2 

select industries.*,
       count(jobs.id) as count
  from industries
  left 
  join jobs 
    on jobs.industry = industries.id
   and jobs.status = 'on'
 group
    by industries.id
 order
    by industries.industry
3

Perfect, that works now - thank you for your help.