List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:April 4 2013 9:07am
Subject:Re: Join query returning duplicate entries
View as plain text  

----- 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
identical.


-- 
Linux Kriek Wanderung
April 19-21, 2013
http://www.tuxera.be/lkw
Thread
Join query returning duplicate entriesTrimurthy4 Apr
  • Re: Join query returning duplicate entriesLucky Wijaya4 Apr
    • Re: Join query returning duplicate entriesJohan De Meersman4 Apr
  • Re: Join query returning duplicate entriesshawn green4 Apr