I have 3 fields in my view:

SSN, Name, Amt

I am trying to find duplicate SSN but my query keeps returning none. I have tried the following but to no avail, it doesn't return any rows:

SELECT MAX(Prodti.p_name), MAX(Prodti.p_amt), COUNT(Prodti.p_ssn);
 FROM ;
     ti!prodti;
 GROUP BY Prodti.p_ssn, Prodti.p_name, Prodti.p_amt;
 HAVING  COUNT(Prodti.p_ssn) > ( 1 );
 ORDER BY Prodti.p_ssn

and also

SELECT MAX(Prodti.p_name), MAX(Prodti.p_amt), Prodti.p_ssn, count(*);
 FROM ;
     ti!prodti;
 GROUP BY Prodti.p_ssn, Prodti.p_name, Prodti.p_amt;
 HAVING  count(*) > ( 1 );
 ORDER BY Prodti.p_ssn

Can someone tell me what I am missing here. I am using VFP8 by the way.

Thanks
Nick Patel