求一SQL简单语句

[khepri]

--首先判断，mNo是否属于 【mStart ,mEnd】范围，如果是的,更新mMemo=mArea,否则不处理
表1 table_area

mStart ,mEnd , mArea

5000 5999 河北
6000 6999 北京
7000 7800 天津



表2 table_no

mNo,mMemo
5001 NULL
8001 NULL

[liangCK]

UPDATE A SET
    mMemo = B.mArea
FROM tb2 AS A
   JOIN tb1 AS B
ON A.mNo BETWEEN B.mStart AND B.mEnd 

[子陌红尘]

update a
set 
    mMemo=b.mArea  
from
    table_no a,table_area b
where
    a.mNo between a.mStart and a.mEnd

[moli_1980]

update table_no set mMemo=mArea where mno between mStart and mEnd

[moli_1980]

update table_no set mMemo=mArea where mno between mStart and mEnd

[khepri]

一楼二楼正解，谢谢了。
moli_1980 的回复是错误的，辛苦分。