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