数据库多表更新

sqlserver:

update a set a.fenqu=b.fenqu
from j2_unitcode a
inner join j2_unitcode_bak b 
on a.code=b.code and len(b.code)=6 and len(isnull(b.fenqu,''))>0

 access:

update 小班注记 a inner join symbology  b  on  b.字段代码=a.c_yssz set a.c_fuhao=b.符号名称
where a.C_DILEI in ( '111', '112','113', '114' )  AND  a.D_MJ <= 1 AND  a.C_LZ <> '253'  AND  a.C_XBLX ='1' and 
b.符号字段='c_yssz'