select *
from az az
inner join ak ak on ak.ak_aa = az.az_aa and ak.ak_anr = az.az_anr