Vazba

SQL vazba z tabulky kgz na tabulku smc

select *
from kgz kgz
left outer join smc smc on smc.smc_idpk = kgz.kgz_cen_smc