>want to refine my question. now i see the bigger picture.
>
>Want a sql result set that contains certain records from table1, and have matching records from table2.
>
>currently i have an sql that selects the desired records from table1. then i loop and readi each of those records and seek against table2. if the seek is not successful then i delete the result record. taking about 1 minute.
>
>any ideas how to make this more efficient.
>
>brenda

Select * From Table1 where MatchKey IN (Select MatchKey From Table2)