select * from PFPLAN_POL pfplan_pol left outer join OCNOS ocnos on ocnos.idpk = pfplan_pol.idpk_ocnos