select * from D1_FN_PRAC_FCE d1_fn_prac_fce left outer join DCISP1 dcisp1 on dcisp1.idpk = d1_fn_prac_fce.idpk_do_tarif