Access中Update inner join set a=b 用法

DatabaseWrapper dbWrap = new DatabaseWrapper(outputMdbPath);<br /> string x = "";<br /> List<string> SQLList = new List<string>();<br /> SQLList.Clear();<br /> //擷取新增建設用地<br /> string xzjsyd = "'水田','水澆地','旱地','園地','林地','牧草地','設施農用地','農村道路','坑塘水面','農田水利用地','田坎','河流水面','湖泊水面','灘涂','自然保留地'";<br /> x = "create table xzjsyd_xp(bsm_1 INTEGER,dlmj double) ";<br /> SQLList.Add(x);<br /> x = "insert into xzjsyd_xp(bsm_1,dlmj) select bsm_1,sum(tbdlmj_xp)*0.0001 as dlmj from " + outRegTableName + " where dlmc in(" + xzjsyd + ") group by bsm_1 ";<br /> SQLList.Add(x);<br /> x = "update " + Name_Mzzdjsxm + " a inner join ";<br /> x += " xzjsyd_xp b ";<br /> x +=" on a.bsm=b.bsm_1 set a.XZJSYD=b.dlmj";<br /> SQLList.Add(x);<br /> //擷取建設佔用耕地<br /> string jszygd = "'水田','水澆地','旱地'";<br /> x = "create table jszygd_xp(bsm_1 INTEGER,dlmj double) ";<br /> SQLList.Add(x);<br /> x = "insert into jszygd_xp(bsm_1,dlmj) select bsm_1,sum(tbdlmj_xp)*0.0001 as dlmj from " + outRegTableName + " where dlmc in(" + jszygd + ") group by bsm_1 ";<br /> SQLList.Add(x);<br /> x = "update " + Name_Mzzdjsxm + " a inner join ";<br /> x += " jszygd_xp b ";<br /> x +=" on a.bsm=b.bsm_1 set a.JSZYGD=b.dlmj";<br /> SQLList.Add(x);<br /> //-----<br /> x = "Create Table ZdjsxmDataMeasureResult(XMLXDM Text(2),XMMC Text(100),JSXZDM Text(2),JSNX Text(10),YDZGM double,XZJSYD double,JSZYGD double,SJCZ Text(200),MS Text(255))";<br /> SQLList.Add(x);<br /> x = "insert into ZdjsxmDataMeasureResult(XMLXDM,XMMC,JSXZDM,JSNX,YDZGM,XZJSYD,JSZYGD,SJCZ,MS) ";<br /> x += " select XMLXDM,XMMC,JSXZDM,JSNX,sum(YDZGM) as YDZGM,sum(XZJSYD) as xzjsyd,sum(JSZYGD) as jszygd,SJCZ,MS ";<br /> x += " from " + Name_Mzzdjsxm + " ";<br /> x += " group by XMLXDM,XMMC,JSXZDM,JSNX,sjcz,ms ";<br /> SQLList.Add(x);<br /> //執行SQL語句<br /> for (int i = 0; i < SQLList.Count; i++)<br /> {<br /> dbWrap.DB.ExecuteQuery(CommandType.Text, SQLList[i]);<br /> }<br /> dbWrap.Dispose();<br /> dbWrap = null; 

Access中Update a inner join b on a.2=b.2  set a.1=b.1  用法

a,b表必須是實體表,實實在在的在資料庫中存在的表!