Hi



Ive got IB_Query with List of animals.

Key field ANIMALID, DAMID, ANIMALNAME



The DAMS(mothers) are linked to their calves by DAMID



The DAMID of a record = the ANIMALID of the Dam.



Now I need a list of all animals that have calved.



How do I get a query for a reporting tool, with the resultset reflecting
only the animals that have calved, but without duplictes that result from a
JOIN.



Mother A has 4 calves = C,D,E,F



If I use JOIN I get:

AC

AD

AE

AF



I only want A to show up once if she has calved, and not 4 X if she has
calved once.



Well suppose I'm confusing you, but tried to keep it as simple as possible.



Thanks in advance



Adrian



[Non-text portions of this message have been removed]