>>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)

having trouble with the actual sql syntax.

select * from table1 where field1 = .t. into resulttable

now only want the rows from resulttable that have a match on field2 and field3 in table2.

obviously i would prefer to get both things done in a single statement, if possible. this is just the easiest way for me to explain it.

thanks brenda