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