In this case, why wouldn't you just use:
SELECT tb1.*;
FROM data1!Table1 tb1, tempquery;
WHERE tb1.id = tempquery.id

(or use a JOIN)

Rick

>When creating views with the VIEW DESIGNER with VFP6 as to obtain a view like:
>SELECT *;
> FROM data1!Table1;
> WHERE Table1.id IN (Select id from tempquery)
>
>No error occurs.
>
>When trying the same operation with VFP7, this is no more possible, and the following error is raised:
>
>"Index does not match the table. Delete the index file and re-create the index"
>
>Is this a (documented) bug or a wanted exclusion by MS?
>
>Strange is that the view can still be created by code.
>
>Thank you in advance.
>Bruno Maddalozzo