select *
from D4_FN_KON_LP_Z d4_fn_kon_lp_z
inner join D4_LP_PECE d4_lp_pece on d4_lp_pece.idpk = d4_fn_kon_lp_z.idpk_lp