>SELECT itemnum, location, RECNO() as recnum ; > FROM curLoc ; > WHERE (location + TRANSFORM(itemnum)) IN ; > (SELECT (location + TRANSFORM(itemnum)) FROM curloc GROUP BY itemnum, location HAVING COUNT(*) > 1) ; > INTO CURSOR curDup >>
>>Item# Location
>>1234 LOC1
>>2345 LOC1
>>2345 LOC2
>>6677 LOC1
>>6677 LOC1
>>
>>>>Item# Location Recno >>6677 LOC1 43 >>6677 LOC1 78 >>>>