title: How to combine multiple column
body: <p>I wanted to combine 11 columns of a form into single column.
  here is my query</p>
  
  <pre><code>SELECT DormData.BuildingID, 
      BuildingDetails.BuildingName, 
      Contractors.Item, 
      ActionDetails.ActionType,
      (DormData.Note1 
          + DormData.Note2 
          + DormData.Note3 
          + DormData.Note4 
          + DormData.Note5
          + DormData.Note6
          + DormData.Note7
          + DormData.Note8
          + DormData.Note9
          + DormData.Note10
          + DormData.Note11) AS Notes
  FROM ActionDetails 
      INNER JOIN (Contractors 
          INNER JOIN (BuildingDetails 
              INNER JOIN DormData 
                  ON BuildingDetails.BuildingID = DormData.BuildingID) 
              ON Contractors.ID = DormData.ItemID) 
          ON ActionDetails.ActionID = DormData.ActionID;
  </code></pre>
  
  <p>But not getting required result.</p>