Re: Help with SQL statement

Jay,

What about:

SELECT DISTINCT QRSTCD,QRAREA,QRBANK, COUNT(ririns) 
FROM REPTDTL JOIN REPTINST ON QRSTCD=RISTCD AND QRAREA=RIAREA AND
QRBANK=RIBANK  AND QRBRPT=RIREPT
WHERE QRRSTA = 'A' AND QRSAMP <> 'Y' AND RIRSTA = 'A' AND RIRINS =
'BUSIC0K'                                          
GROUP BY QRSTCD,QRAREA,QRBANK

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 5-12-2006 at 13:45 Jay Vaughn wrote:

I am getting the following error on the following sql statement.  I want

to 

simply retrieve a number of records "grouped by qrstcd,qrarea,qrbank)...

What am I missing..?
---------------------

Number of arguments for function COUNT not valid.

SELECT COUNT(DISTINCT QRSTCD,QRAREA,QRBANK) FROM REPTDTL            
JOIN REPTINST ON QRSTCD=RISTCD AND QRAREA=RIAREA AND QRBANK=RIBANK  
AND QRBRPT=RIREPT WHERE QRRSTA = 'A' AND QRSAMP <> 'Y' AND RIRSTA = 
'A' AND RIRINS = 'BUSIC0K'