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

Thanks





>

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

>>The table SQLGenData has 77000 records in it. The ResNam column is NOT unique.
>>The ResAvail table however DOES have a unique ResNam column.
>>
>>I want to pull all ResAvail records for the SQLGenData records. There should be only
>>one result record for each distinct ResNam.
>>
>>Is it possible to do this in a JOIN?
>>
>>

>>SELECT SysRecord, ResNam, EffDate, AvailDay, EquivDay, EquivWeek, EquivMnth ;
>>	FROM ResAvail;
>>	WHERE ResNam IN;
>>		(SELECT DISTINCT ResNam;
>>			FROM SQLGenData);
>>	INTO CURSOR Results
>>			
>>

>>
>>