select *
from zc zc
inner join ag ag on ag.ag_aa = zc.zc_aa and ag.ag_anr = zc.zc_anr and ag.ag_az = zc.zc_az and ag.ag_pos = zc.zc_ag