Windows Azure Mobile Services Joined Table View

Data.cs

    public class Data
    {
        public MobileServiceClient MobileService = new MobileServiceClient("", "");

        private IMobileServiceTable<UserGroupExtended> userGroupExtendedTable;

        public async Task<IList<UserGroupExtended>> GetGroupUsers(string groupId)
        {
            return await this.MobileService.GetTable<UserGroupExtended>(new { groupId = groupId }).ToListAsync();
        }
    }

UserGroupExtended.cs

    [DataTable(Name = "userGroup")]
    public class UserGroup
    {
        [DataMember(Name = "id")]
        public int Id { get; set; }

        [DataMember(Name = "userId")]
        public string UserId { get; set; }

        [DataMember(Name = "groupId")]
        public string GroupId { get; set; }

        [DataMember(Name = "friendlyName")]
        public string FriendlyName { get; set; }
    }

    [DataTable(Name = "userGroupsExtended")]
    public class UserGroupExtended : UserGroup
    {
        [DataMember(Name = "userName")]
        public string UserName { get; set; }
    }

UserGroupExtended.read.js

function read(query, user, request) {

    var sql =
        "select [user].name as userName, userGroup.groupId, userGroup.userId, userGroup.friendlyName, userGroup.id " +
        "from userGroup " +
        "inner join [user] on [user].userId = userGroup.userId " +
        "where userGroup.groupId in " +
        "(select groupId from userGroup where userId = ?) and userGroup.groupId = ?;";

    mssql.query(sql, [user.userId, request.parameters.groupId], {
        success: function(results) {
            request.respond(statusCodes.OK, results);
        }
    });

}