Select inv_machine.name machine_name, count(inv_tuner.machine_id) as 'Multiple Tuner ID Count'
from inv_tuner, inv_machine
where inv_machine.id = inv_tuner.machine_id
and inv_tuner.machine_id in (select distinct inv_tuner.machine_id from inv_tuner group by inv_tuner.machine_id having count(*) > 1 )
group by inv_machine.name
order by 2
Comments