select * from LCIOCN_AR lciocn_ar left outer join LCICEN lcicen on lcicen.idpk = lciocn_ar.idpk_lcicen