select *
from D4_LP_ZMENA d4_lp_zmena
inner join D4_RIZ_MERENI d4_riz_mereni on d4_riz_mereni.idpk = d4_lp_zmena.idpk_mereni