Thanks Craig. There are only about 6 fields involved so I don't think it's a big deal.

>It would also speed things up if you didn't SELECT * ... unless of course you need *
>
>>Given a select like this:
>>

>>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.
>>
>>Thanks