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