select *
from kcm kcm
inner join kcz kcz on kcz.kcz_kurz = kcm.kcm_kcz_kn