Vazba
SQL vazba z tabulky sme na tabulku smc
select *
from sme sme
left outer join smc smc on smc.smc_idpk = sme.sme_smc_idpk