Hi,

At Wednesday, July 30, 2008, 12:22 PM, Serge Fonville wrote:

> Currently I have
> SELECT a.ID,a.Name,a.Assignedvalue FROM Persons a WHERE a.Assignedvalue IN
> (SELECT b.Assignedvalue FROM Persons b GOUP BY b.Assignedvalue HAVING
> COUNT(b.assignedVALUE) > 1)
> ORDER BY a.Assignedvalue

> This works, just it takes forever
> I tried Embedded, Superserver and Classic
> All hog the cpu, the difference lies in the memory usage (16,8,3)MB

> Is there a better way to do this?

Have you tried Ruan's example query(using your table names and
fields)? The result should be the same as the query that you just
posted. And, it should be faster and possibly hardly using any CPU.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)