title: How to join tables without repeating a column value multiple times?
body: <p>I have 3 tables: images, colors and tags.
  Each image has 2 colors and at least 1 tag.
  And I want my users to individually search for tags or/and colors.</p>
  
  <p>The problem is when I'm joining the tables I get rows that have the same value in the columns multiple times.</p>
  
  <pre><code>SELECT images.id, tag, color
  FROM images
  JOIN tags ON tags.image_id = images.id
  JOIN colors ON colors.image_id = images.id
  WHERE images.id = 1
  
  I get:
  image_id: 1, tag: sky, color: blue
  image_id: 1, tag: cloud, color: blue
  image_id: 1, tag: sky, color: white
  image_id: 1, tag: cloud, color: white
  
  But the result I want is something like:
  image_id: 1, tag1: sky, tag2: cloud, color1: blue, color2: white
  </code></pre>
  
  <p>Is this possible somehow? Or should I just change database design?</p>