title: Return multiple roles for user in 1 column not multiple rows
body: <p>SQL Server</p>
  <p>I am trying to return 1 row for a user that contains their firstname, lastname, email etc and also all their roles contained in a separate roles table connected through UserRoles.</p>
  <pre><code>User              -&gt;     UserRoles         -&gt;    Role
  -------------            ---------------         ------------
  Email                    UserEmail               Id
  Firstname                RoleId                  Name
  Lastname
  Phone
  IsActive
  
  </code></pre>
  <pre><code>  declare @Email nvarchar(100);
    set @Email = 'testemail@gmail.com'
    
    SELECT [User].Email, Password, Username, Firstname, Lastname, Phone, IsActive, EmailVerified, IsBanned, BanStart, BanEnd, [Role].Name as Roles
    FROM dbo.[User], [UserRole], [Role] 
    WHERE [User].Email = @Email AND UserRole.UserEmail = [User].Email AND UserRole.RoleId = Role.Id
  
  </code></pre>
  <p>Return</p>
  <pre><code>Email               Username            Firstname Lastname Phone IsActive EmailVerified IsBanned BanStart BanEnd Roles     
  testemail@gmail.com testemail@gmail.com daniel  brownn  3199999999  1   0   0   NULL    NULL    Expert
  testemail@gmail.com testemail@gmail.com daniel  brownn  3199999999  1   0   0   NULL    NULL    User
  </code></pre>
  <p>This returns the correct info unfortunately for a user with 2 roles it returns 2 separate rows. I aim to have 1 row returned with a comma separated value in the Roles column containing both the roles values. Is this possible?</p>
  <p>Thanks!</p>