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
>			
>

>
>