Hi,

I try to find distinct values in a group with a query like this:

select id1, count(distinct 'field') as cntfld form table1 group by id1

and values in cntfld is incorrect, different from second aproach like this:

select distinct 'field' from table1 where id1=somevalue

number of records in second case is different from cntfld form first case for same value of id1

In SQL server first form of select works ok. In VFP is something wrong?

Thanks