Vazba
SQL vazba z tabulky LOC1 na tabulku LCICEN
select *
from LOC1 loc1
left outer join LCICEN lcicen on lcicen.idpk = loc1.idpk_lcicen