----- Original Message -----
> From: "Lucky Wijaya" <luckyx_cool_boy@stripped>
> To: mysql@stripped
> Sent: Thursday, 4 April, 2013 10:51:50 AM
> Subject: Re: Join query returning duplicate entries
> Hi, sorry i tried to help but i hardly understand the use of join in
> your query since the joined table is not used anywhere.
Of course it's used - the joined subquery limits the items to male or female birds.
As for an answer to your question, Trimurthy, just use SELECT DISTINCT <rest of your
query>. The cause of the duplicates may be that the iac for male and female birds is
Linux Kriek Wanderung
April 19-21, 2013