title: SQL flat table query
body: <p>I have imported some data from an excel table in to an SQL table and I now need to write a view over the data to combine it with some other fields.</p>
  
  <p>My problem is that the table is in the following form with these columns;</p>
  
  <p><strong>Name</strong>    <strong>Project_One_ID</strong>    <strong>Project_Two_ID</strong>    <strong>Project_Three_ID</strong></p>
  
  <p>Rather than the form I could use, which would be a link table with columns like this;</p>
  
  <p><strong>Name</strong>  <strong>ProjectID</strong></p>
  
  <p>Is it possible to convert this type of table? Or use it as it is? I could do it in code but im struggling in SQL.  I have two other tables that need to link on to either side of this link table to create my overall view.</p>
  
  <p>Thanks for any pointers,</p>