* OR-SYSTEM Open
select * from E0PRNO e0prno left outer join O1ROLE o1role on o1role.orole = e0prno.idpk_o1role