select * from C1ZAHR3C c1zahr3c left outer join C1ZAHR1 c1zahr1 on c1zahr1.idpk = c1zahr3c.idpk_czahr1