select *
from D4_FN_KON_CINN_Z d4_fn_kon_cinn_z
left outer join D1_FN_PRAC_FCE d1_fn_prac_fce on d1_fn_prac_fce.idpk = d4_fn_kon_cinn_z.idpk_funkce