Vazba
SQL vazba z tabulky PUC na tabulku PNOS
select *
from PUC puc
left outer join PNOS pnos on pnos.idpk = puc.idpk_nn_sloz