use refdocswithaddress APPEND FROM refdocsaddy speciality,location FOR refdocsaddy.number = refdocswithaddress.number