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.
>SELECT SysRecord, ResNam, EffDate, AvailDay, EquivDay, EquivWeek, EquivMnth ; > FROM ResAvail; > WHERE ResNam IN; > (SELECT DISTINCT ResNam; > FROM SQLGenData); > INTO CURSOR Results > >>