You're thinking VFP way instead of SQL way. You should work with SQL Server or some other client server RDBMS more. :)

>After I posted my initial message I thought about the same approach you are suggesting. And actually it should work even better as the tables do have indexes on both fields. I just keep forgetting that the JOIN does not have to be only ON one field but can have the AND clause.
>
>Thank you very much for your help.
>
>>It depends on what indexes you have. If you have indexes on each int field than
>>

>>select * from mytable1 join mytable2 ;
>>  on mytable1.intfld1 = mytable2.intfld1 and mytable1.intfld2 = mytable2.intfld2
>>

>>
>>It's also standard SQL that will run on most other backends w/o modifications.
>>
>>>