It was initially
SELECT UniqueID,PassCode,DupCode,Priority,CNT(*) as GroupCount ;
FROM crsMatchResults ;
INTO CURSOR crsMatchResults ;
GROUP BY UniqueID,PassCode,DupCode,Priority ;
HAVING GroupCount>1
READWRITE NOFILTERbut I've played with it a little trying to get it to work.
Aloha,
James
>
Here's the actual commands:
>
>>*!* Then try to SELECT with only the fields required in the output cursor
>SELECT UniqueID,PassCode,DupCode,Priority ;
> FROM crsMatchResults ;
> INTO CURSOR crsMatchResults ;
> GROUP BY UniqueID,PassCode,DupCode,Priority ;
> READWRITE NOFILTER
>
>
>Am I missing something here? Why are you using a GROUP BY clause? I do not see any aggregate field in the SELECT field list.
