select * from D0PLAN d0plan left outer join D0_PL_ETYPE d0_pl_etype on d0_pl_etype.idpk = d0plan.idpk_event_type