MS SQL - Name concatenation - Multiple Users : I am trying to concatenate multiple users into a singular string. Here is an example of my DB Model:

    dbo.Users

    | UserId | AccountId | Title | FirstName | LastName |
    | 1234   | 1001      | Mr    | John      | Banks    |   
    | 1235   | 1001      | Mrs   | Georgia   | Banks    |
    | 1236   | 1002      | Mr    | Chris     | Aims     |
    | 1237   | 1002      | Mrs   | Caroline  | Hole     |


    dbo.Account
    
    | AccountId | SignUpDate | LastLoginDate |
    | 1001      | 20/08/2017 | 13/06/2018    |
    | 1002      | 20/08/2017 | 13/06/2018    |

I want to be able to get these users in a string like this:

Account 1001: 
Mr J & Mrs G Banks

Account 1002:
Mr C Aims & Mrs C Hole

Can anyone make any suggestions? 

Thanks


