select * from D1_FN_PRAC_FCE d1_fn_prac_fce left outer join DCISZ dcisz on dcisz.idpk = d1_fn_prac_fce.idpk_obor