>>Hi,
>>I have two tables with one-to-many relation.
>>Is there a way - in one sql statement - to count all the records
>>which have only one record relation in the "many" table.
>>
>>Thanks.
>
>Untested:
>
>

>SELECT PKinOneTable ;
>   FROM TheManyTable ;
>   GROUP BY PKinOneTable ;
>   HAVING CNT(*) = 1 ;
>   INTO CURSOR OnlyOneChild
>

>
>Tamar

Thanks, it's ok but the problem is that it doesn't count the records but lists them.