It may work in VFP9 only. The previous versions do not support derived tables.

>I am trying to compile this in VFP 7, and it's failing. I'm guessing it doesn't
>like the DISTINCT. How can I do this in 7?
>
>

>SELECT SysRecord, ResNam, EffDate, AvailDay, EquivDay, EquivWeek, EquivMnth;
>    FROM ResAvail ra;
>    JOIN (SELECT DISTINCT ResNam FROM SQLGenData) sgd ON sgd.ResNam = ra.ResNam;
>    INTO CURSOR Resultsa
>