title: select query statement
body: <p>Hy all..I have an issue regarding a query.I have 3 tables and what I want to do is combine them to get to a good looking result.So I have the following 3 tables:</p>
  
  <pre><code>  personal
  - cod_numeric_personal
  - nume
  
  
    Raspunsuri
  - raspuns
  - cod_numeric_personal
  - data_raspuns
  - id_intrebare
  
    Intrebari
  -intrebari
  -id_intrebare
  </code></pre>
  
  <p>I did this query:</p>
  
  <pre><code>SELECT personal.nume, Raspunsuri.raspuns, Intrebari.intrebari
  FROM personal
  INNER JOIN Raspunsuri ON personal.cod_numeric_personal = Raspunsuri.cod_numeric_personal
  INNER JOIN Intrebari ON Raspunsuri.id_intrebare = Intrebari.id_intrebare
  </code></pre>
  
  <p>This brings up the name of the user,the answer and the question for each answer.What I want is to bring up the name only once and the each question that is "intrebare" to be tha name of the column and for each column the answer.So like..Intrebare1...Answer1...but Intrebare1 being the name of the column.</p>