select *
from D1_FN_KON_LP d1_fn_kon_lp
inner join D1_FN_PRAC_FCE d1_fn_prac_fce on d1_fn_prac_fce.idpk = d1_fn_kon_lp.idpk_funkce