title: Select multiple rows into one variable in SQL Query
body: <pre><code>SELECT ft.ThreadTitle AS Title, 
  fr.ReplyText + ' ' + ua2.Username + ' ' + ft.ThreadText + ' '  +
  
  -- THIS NEXT LINE IS WHAT I WANT TO ACHIEVE:
  
  (Select ReplyText from ForumReply Where ThreadID=ft.ThreadID) 
  
  -- THE ABOVE LINE HAVE MULTIPLE ROWS/VALUES THAT I WANT TO JOIN INTO ONE VARIABLE. HOW?
  AS [Content], 
  
  ss.Domain, 
  ss.SiteID, 
  ft.ThreadID AS ObjectId
  FROM         dbo.ForumReply AS fr INNER JOIN
                        dbo.ForumThreads AS ft ON fr.ThreadID = ft.ThreadID INNER JOIN
                        dbo.User_Account AS ua1 ON ft.CreateByUserID = ua1.UserID INNER JOIN
                        dbo.User_Account AS ua2 ON fr.ReplyUserID = ua2.UserID INNER JOIN
                        dbo.SysT_Site AS ss ON ua1.SiteID = ss.SiteID
  </code></pre>
  
  <p>This query gives error:
  <em>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.</em></p>
  
  <p>How do I rewrite this query to work so that I get all the values into one variable? The end result need to be a "View" that looks like this:</p>
  
  <p>.ObjectID int</p>
  
  <p>.Content (string with all text that exists in the Forumthread.threadText and forumReply.ReplyText)</p>
  
  <p>.Domain string</p>
  
  <p>.SiteID int</p>