How can I make a count to return also the values with 0 in it.
select count(1), equipment_name
where equipment_name in (
select eqp from ne_db.ne_list)
Group by equipment_name
SELECT a.eqp, COUNT(b.equipment_name) totalCount FROM ne_db.ne_list a LEFT JOIN alarms.new_alarms b ON a.eqp = b.equipment_name GROUP BY a.eqp