* OR-SYSTEM Open
select * from C1DIETY c1diety left outer join C1ZAHR1 c1zahr1 on c1zahr1.idpk = c1diety.idpk_czahr1