select *
from D4_FN_KON_CINN d4_fn_kon_cinn
left outer join D4_FN_PRAC_FCE d4_fn_prac_fce on d4_fn_prac_fce.idpk = d4_fn_kon_cinn.idpk_funkce