How do I write an update query to update to the min value by taking one id from other table

See more:

SQL

SqlDataSource

mbr table

mid    mnum
1      10
1      11
2      12
2      13
3      14
3      15


nm table

mnum   name
10      x
11      x
11      x
12      y
13      y
14      z
15      z
14      z


expected output

nm table

mnum   name
10      x
10      x
10      x
12      y
12      y
14      z
14      z
14      z

as there are so many rows i want a query that update all the rows with out hard coded values

What I have tried:

i tried with logic of selecting max mnum from mbr table and select min mnum from nm table and use update query to update max to min.it is updating every thing