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