>>>>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.
VFP has no CROSS JOIN :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.