SELECT TOP 1 TeamId FROM UsersHistoryes WHERE UserId=94 ORDER BY UserHistorysId DESC

SELECT Users.UserId, UserFullName, UserLogin, TeamId FROM Users
    INNER JOIN UserHistories ON UserHistories.UserId = Users.UserId
    --WHERE Users.UserId=Users.UserId
    --Group BY Users.UserId
            ORDER BY Users.UserId

SELECT Users.UserId, UserFullName, UserLogin,
(SELECT top 1 teamid FROM UserHistories WHERE UserId=userlogin ORDER BY UserHistoryID DESC) TeamId
FROM Users