Middlesex were relegated from Division One after losing to Nottinghamshire by two wickets in a thrilling final day of the County Championship season.
