select * from D1_FN_KON_CINN d1_fn_kon_cinn left outer join D1_FN_PRAC_FCE d1_fn_prac_fce on d1_fn_prac_fce.idpk = d1_fn_kon_cinn.idpk_funkce