Bob,

Could you plese post your SQL?
Subquieries are supported by VFP. You may use it incorrectly.

>I still get a queries of this type are not supported error when using the IN clause for the sub-query.
>
>(I created a couple of table to test the solution out).
>
>
>>Nonsense. You can have them. But the correct syntax is WHERE something IN (subquery) not something = subquery as it appeared in the original question.
>>
>>That doesn't mean that a subquery is needed here.