title: How get some columns vertically in SQL
body: <p>I'm having a problem with a SQL statement. I would like to show some data from some tables; this is my SQL Diagram:</p>
  
  <p><a href="https://i.stack.imgur.com/k2gjP.jpg" rel="nofollow noreferrer">Database diagram</a></p>
  
  <p>I would like to show some information from the table called "Signatures",
  I would like to show in on row the columns: "IdSupervisor,IdManager,IdSupervisor2,IdManager2")
  And below this info, i would like to show these columns: "FirmaS1,FirmaG1,FirmaS2,FirmaG2).</p>
  
  <p>I've searched on the web with no success.</p>
  
  <p>This is the SQL Query that I made to achieve it in two different statements, 
  but I want to have the two queries in one.</p>
  
  <h2>Query 1:</h2>
  
  <pre><code>SELECT p1.Name as 'Supervisor', coalesce(p2.Name,'Unnecessary') as 'Manager', coalesce(p3.Name,'Unnecesary') as 'New Supervisor', coalesce(p4.Name,'Unnecesary') as 'New Manager' 
  FROM Signatures s1
  LEFT JOIN PersonalDepartment dp ON s1.IdSupervisor = dp.IdPersonalDepartment
  LEFT JOIN Personal p1 ON dp.IdPersonal = p1.IdPersonal
  LEFT JOIN PersonalDepartment dp2 ON s1.IdManager = dp2.IdPersonalDepartment
  LEFT JOIN Personal p2 ON dp2.IdPersonal = p2.IdPersonal
  LEFT JOIN PersonalDepartment dp3 ON s1.IdSupervisor2 = dp3.IdPersonalDepartment
  LEFT JOIN Personal p3 ON dp3.IdPersonal = p3.IdPersonal
  LEFT JOIN PersonalDepartment dp4 ON s1.IdManager2 = dp4.IdPersonalDepartment
  LEFT JOIN Personal p4 ON dp4.IdPersonal = p4.IdPersonal WHERE IdRequest = 64;
  </code></pre>
  
  <h2>Query 2:</h2>
  
  <pre><code>SELECT FirmaS1, FirmaG1, FirmaG1, FirmaG2 FROM Signatures WHERE IdRequest = 64;
  </code></pre>
  
  <p>Result:</p>
  
  <p><a href="https://i.stack.imgur.com/Oo5Gz.jpg" rel="nofollow noreferrer">Result of the two querys.</a></p>