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