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