>>>UPDATE. Replacing CROSS JOIN with just a comma fixed the problem.
>>
>>Yes, that must be it. I recently learned the CROSS JOIN syntax in an Oracle course; it seems that it isn't supported by Visual FoxPro.
>
>
>Too many WHERE clauses also :-)
>To have something like CROSS JOIN in VFP you could do something like this:
>

>CREATE CURSOR crsTest1 (Fld1 I)
>CREATE CURSOR crsTest2 (Fld1 I)
>INSERT INTO crsTest1 VALUES (1)
>INSERT INTO crsTest2 VALUES (1)
>INSERT INTO crsTest2 VALUES (2)
>
>SELECT *;
>FROM crsTest1, crsTest2
>
>*** or
>SELECT *;
>FROM crsTest1;
>INNER JOIN crsTest2 ON 1=1
>

The CROSS JOIN syntax I used is perfectly valid in SQL Server, so VFP seems to have problems with the CROSS JOIN.