select * from C1ZALOHY c1zalohy left outer join C1ZAHR1 c1zahr1 on c1zahr1.idpk = c1zalohy.idpk_czahr1