select *
from D4_LP_ZMENA d4_lp_zmena
inner join D4_LP_PECE d4_lp_pece on d4_lp_pece.idpk = d4_lp_zmena.idpk_pece