Vazba
SQL vazba z tabulky C1DIETY na tabulku C1ZAHR1
select *
from C1DIETY c1diety
left outer join C1ZAHR1 c1zahr1 on c1zahr1.idpk = c1diety.idpk_czahr1