>select * from ofInterest ; >left join parcels p1 on ofInterest.parcel = p1.fromparcel ; >into table c:\join1 >>would it speed things up if either of the tables were indexed and on which field? These are both large tables and I'm finding the query takes several minutes to execute. Plus I need to run several iterations of this so it all takes a long time.