>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