Vazba
SQL vazba z tabulky zh na tabulku pro
select *
from zh zh
left outer join pro pro on pro.pro_oscis = zh.zh_pers