--首先判断,mNo是否属于 【mStart ,mEnd】范围,如果是的,更新mMemo=mArea,否则不处理
表1 table_areamStart ,mEnd , mArea 5000 5999 河北
6000 6999 北京
7000 7800 天津 表2 table_nomNo,mMemo
5001 NULL
8001 NULL
表1 table_areamStart ,mEnd , mArea 5000 5999 河北
6000 6999 北京
7000 7800 天津 表2 table_nomNo,mMemo
5001 NULL
8001 NULL
mMemo = B.mArea
FROM tb2 AS A
JOIN tb1 AS B
ON A.mNo BETWEEN B.mStart AND B.mEnd
set
mMemo=b.mArea
from
table_no a,table_area b
where
a.mNo between a.mStart and a.mEnd
moli_1980 的回复是错误的,辛苦分。