>That runs in the 30-40 second range as well. I am a little surprised that the WHERE ... IN (SELECT ...) syntax is so much slower. I will just use the JOIN.
>

The VFP query optimizer is very primitive. If you run similar queries on MS SQL Server you wouldn't see a big difference between them at all.