title: mysql GROUP_CONCAT duplicates
body: <p>I make my join from a farmTOanimal table like this.  There is a similar farmTotool table</p>
  
  <pre><code>id | FarmID  | animal
   1 |    1    | cat
   2 |    1    | dog
  </code></pre>
  
  <p>When I join my tables in a view, I get a result that looks like this</p>
  
  <pre><code>FarmID | animal | tool
     1   |  cat   | shovel
     1   |  dog   | shovel
     1   |  cat   | bucket
     1   |  dog   | bucket
  </code></pre>
  
  <p>Now, I do GROUP BY FarmID, and GROUP_CONCAT(animal) and GROUP_CONCAT(tool), i get</p>
  
  <pre><code>FarmID |     animals     |         tools
    1    | cat,dog,cat,dog | shovel,shovel,bucket,bucket
  </code></pre>
  
  <p>But, what I really want is a result that looks like this.  How can I do it?</p>
  
  <pre><code>FarmID | animals |    tools
    1    | cat,dog | shovel,bucket
  </code></pre>