select * from C1ZALMIM c1zalmim left outer join C1ZAHR1 c1zahr1 on c1zahr1.idpk = c1zalmim.idpk_czahr1