title: SQL get two columns side by side one multiple value one unique value
body: <p>My problem is little unqiue, I tried finding but did not find desired answer,</p>
  
  <p>I have two columns in my database, one is a and b consider "A" having ids and "B" having colors, now I am achieving half of what I want, is When I try to look for B column the ids repeat for example</p>
  
  <pre><code>1 Black
  1 Black
  2 Blue
  2 Blue
  2 Blue
  3 White
  </code></pre>
  
  <p>now all I want is getting these columns and getting another two columns added to the same query that then show unqiue of column "A" and its color for example;</p>
  
  <pre><code>A B       C
  1 Black   1 Black
  1 Black   2 Blue
  2 Blue    3 White
  2 Blue
  2 Blue
  3 White
  </code></pre>
  
  <p>Is it possible ?</p>