select * from C1ZAHR3C c1zahr3c left outer join C1ZAHR2 c1zahr2 on c1zahr2.idpk = c1zahr3c.idpk_czahr2