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