Re: ask select join

[Peter Brawley]

Something like ...

select t1.idserver, sum( if(t2.status='failed',1,0) ) as failed
from t1
join t2 using (idserver)
group by t1.idserver;