* OR-SYSTEM Open
select * from MPREN1 mpren1 left outer join LCICEN lcicen on lcicen.idpk = mpren1.idpk_lcicen