>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

post a 2 records example