Here it is:
SELECT temp.mnemonic, ata, name, class, type, status, CNT(*) FROM temp ;
INTO TABLE assignee_temp ;
WHERE group = gcGroup AND dept = gcDept ;
AND BETWEEN(assign_date,gdStartDate,gdEndDate) ;
GROUP BY 1,2,3
>What is the SQL statement you have tried that does not work?
>
>Jeff
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.