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