mohlo by to pomoct, este som to neotestoval :)
skusim si to hodit do databazy a overim to
SELECT T2.IDR, T1.NAZEV, IFNULL(COUNT(T2.IDR), 0)
FROM TAB2 T2
RIGHT JOIN TAB1 T1 ON T2.IDR = T1.ID
GROUP BY T2.IDR, T1.NAZEV
ORDER BY COUNT(T2.IDR) DESC
EDIT: doplnene descending zoradovanie ;)
otestoval som to u seba a ide to. Jediny problem je, ze pri software sa nezobrazuje ID nadradeneho riadku.
takze vysledok je
1 - Pocitac - 2
3 - Hardware - 1
null - software - 0