select *
from ap ap
left outer join ma ma on ma.ma_nr = ap.ap_mag