title: SQL Using values in row to create different columns
body: <p>I have several tables in my database and want to select a couple columns from a couple tables, which is all fine. Now, there is a 3rd table, and this table has a column that has different text values in it, but the same few "text_values" for different users, for instance:</p>
  
  <p>table3</p>
  
  <pre><code>row userid  text_value  value
  1   user1   text1       value1
  2   user1   text2       value2
  3   user2   text1       value3
  4   user3   text1       value4
  ...
  </code></pre>
  
  <p>Now, I want to take INFO1 and INFO2 from Table1, INFO3 and INFO4 from Table2, but then I want to take all the values from Table3 where text_value=text1 and make this a 5th column with INFO5, and then take values from Table3 where text_value=text2 and make this a 6th column with INFO 6.</p>
  
  <p>I have the following query, which WORKS fine if I ONLY want the INFO5 column:</p>
  
  <pre><code>SELECT Table1.INFO1, Table1.userid , Table2.INFO2,
  Table1.INFO3, Table2.INFO4,
  Table3.value AS INFO5
  FROM Table1 LEFT OUTER JOIN Table2 ON Table1.userid = Table2.userid 
  LEFT OUTER JOIN Table3 ON Table1.userid = Table3.userid 
  WHERE Table3.text_value = 'text1' 
  </code></pre>
  
  <p>However, I want to have another column created using the values from the same table3 VALUE column, but when TEXT_VALUE = 'text2' (this is true for 'text3', 'text4', as there are several texts to "filter" on).</p>
  
  <p>When I change the query to the following, it doesn't work:</p>
  
  <pre><code>SELECT Table1.INFO1, Table1.userid , Table2.INFO2,
  Table1.INFO3, Table2.INFO4,
  Table3.value AS INFO5 WHERE Table3.text_value = 'text1' 
  Table3.value AS INFO6 WHERE Table3.text_value = 'text2' 
  FROM Table1 LEFT OUTER JOIN Table2 ON Table1.userid = Table2.userid 
  LEFT OUTER JOIN Table3 ON Table1.userid = Table3.userid 
  </code></pre>
  
  <p>Any guidance will be appreciated.</p>