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