select * from za za left outer join ag ag on ag.ag_aa = za.za_aa and ag.ag_anr = za.za_anr and ag.ag_az = za.za_az and ag.ag_pos = za.za_ag