select * from lbf lbf left outer join az az on az.az_aa = lbf.lbf_aa and az.az_anr = lbf.lbf_anr and az.az_pos = lbf.lbf_az