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