Martin,

You need to use the DISTINCT part of the COUNT clause:

select field1 as site, count(distinct field2) ;
  from testselect ;
  group by site

Also, my understanding is that the GROUP BY clause in VFP's version of SQL works on the result set, not the input set. This means that you'll need to GROUP BY SITE, rather than field1. Alternatively you could just refer to the field's ordinal position - e.g. GROUP BY 1

Cheers,

Andrew

>Hi guys!
>
>I have a table with the next rows:
>
>field1 field2
>Site A Cell 101
>Site A Cell 101
>Site A Cell 102
>Site A Cell 102
>Site A Cell 103
>Site A Cell 104
>Site B Cell 201
>Site B Cell 201
>Site B Cell 205
>
>
>well, I am locking for sql statment that produces the next dataset result:
>Site Cells_Working
>Site A 4
>Site B 2
>
>I'am trying with :
>Select field1 as site,count(field2) as Cells_working from mytable group by; field1
>but it doesn´t work
>Thanks in advance
>martin Alcaraz
>malcaraz@rtn.uson.mx