select count(*) from hradselect h.*, s.nazev from hrad h inner join strasidlo s on s.hrad = h.idupdate hrad set nazev='Radyně' where id='1'select h.i_d, count(s.*) as pocet_strasidel from hrad h inner join strasidlo s on s.hrad = h.id group by h.id