Vazba
SQL vazba z tabulky zhp na tabulku zh
select *
from zhp zhp
left outer join zh zh on zh.zh_kn = zhp.zhp_zh_kn