select * from LCICEC_AR lcicec_ar left outer join LCICEN lcicen on lcicen.idpk = lcicec_ar.idpk_lcicen