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