>Is it possible to do this:
>I want to select the accounts, but only if there is more than one account in a category.
>It doesn't like the subquery.
>
>

>Select * From vcf!accounts a ;
>	WHERE a.cCategory In ;
>(Select b.cCategory, Count(b.cCategory) As nmany From vcf!accounts b Group By b.cCategory Having nmany>1) ;
>	ORDER By a.cCategory, a.ndispord, a.cname
>

>
>Cyril

Select * From vcf!accounts a ;
	WHERE cCategory In ;
(Select cCategory From vcf!accounts Group By 1 Having Count(*)>1) ;
	ORDER By cCategory, ndispord, cname