"If you are doing a SELECT ... WHERE IN (SELECT ...) style query, check to see if it's functionally equivalent to an INNER JOIN. This can make a HUGE difference."

Is this statement true, that an inner join is faster than WHERE IN (SELECT ...)?
Does this differ in VFP vs MSSQL?