请问在ACCESS表中已有两个字段A和B而C字段正好是A*B能不能让C自动填入A*B的值
access \u5c06\u4e00\u4e2a\u8868\u4e2d\u6240\u6709\u7b26\u5408\u6761\u4ef6\u7684\u67d0\u5b57\u6bb5\u7684\u503c\u66f4\u65b0\u5230\u53e6\u4e00\u4e2a\u8868\u4e2d\u7684\u67d0\u4e2a\u5b57\u6bb5update a inner join b on a.a_x=b.b_xx set a.a_y=b.b_yy\u8fd9\u6837\uff1f
\u5148\u505a\u597da\u8868\u7684\u5907\u4efd
\u7531\u4e8e\u767e\u5ea6\u77e5\u9053\u65b0\u6539\u7248\u540e\u5f88\u70c2\uff0c\u8ffd\u95ee\u770b\u4e0d\u5230\uff0c\u8bf7\u8ffd\u95ee\u540e\u5e76\u79c1\u4fe1\u4e00\u4e0b\uff0c\u4ee5\u4fbf\u53ca\u65f6\u89e3\u51b3\uff0c\u8c22\u8c22
update table2 set table2.\u5426\u96c6\u56e2\u516c\u53f8=table1.\u5426\u96c6\u56e2\u516c\u53f8 from table1 where table2.\u4f9b\u5e94\u5546ID=table1.\u4f9b\u5e94\u5546ID
update table2 set table2.\u5426\u96c6\u56e2\u516c\u53f8='\u5426' where table2.\u4f9b\u5e94\u5546ID not in (select \u4f9b\u5e94\u5546ID from talbe1)
绛旓細绱㈠紩鎴栦富鍏抽敭瀛椾笉鑳藉寘鍚竴涓 绌 (Null) 鍊笺傝繖涓槸浣犵殑涓婚敭娌℃湁鍊艰屾棤娉曟彃鍏 涓鑸槸涓婚敭璁剧疆涓鸿嚜澧炵被鍨嬬殑鍊 鐒跺悗浣犲氨涓嶇敤鏉ユ彃鍏ヤ竴涓间簡 鎵撳紑鏁版嵁搴 鎶婁富閿缃负鑷绫诲瀷銆
绛旓細搴旇鍙互杩涜INNER JOIN鏌ヨ锛屼絾鏄ACCESS搴旇娌℃湁SQLSERVER閭d箞寮哄ぇ鍚э紝SQLSERVER鍙互閫氳繃璁剧疆涓诲閿揪鍒拌嚜鍔ㄥ垹闄ゃ
绛旓細鐚滄兂gaha001鏄兂瑕佷竴涓柊鐨勬煡璇紝鏄剧ず杩欐牱鐨勭粍鍚堢粨鏋滃惂锛熷鏋滄槸杩欐牱鐨勮瘽锛岀敤涓嬮潰鐨凷QL鍙互瀹炵幇锛歴elect ([store_name] & [sku]) as 鏂板瓧娈靛悕 from 琛ㄥ悕
绛旓細鍙互灏涓や釜琛ㄧ殑鎵嬫満鍙风爜鍏宠仈鏉ュ緱鍒伴渶瑕佺殑璧勬枡 濡備袱涓〃鍒嗗埆涓篈,B 鏄彲浠 select A.鎵嬫満鍙风爜 from A,B where A.鎵嬫満鍙风爜 = B.鎵嬫満鍙风爜
绛旓細鍏跺畠鍥炵瓟: 鍦ˋccess鎴朣QL SERVER涓敤SQL鍒犻櫎閲嶅璁板綍鐨凬绉嶆柟娉 2009-11-10 16:34 渚嬪锛 id name value 1 a pp 2 a pp 3 b iii 4 b pp 5 b pp 6 c pp 7 c pp 8 c iii id鏄富閿 瑕佹眰寰楀埌杩欐牱鐨勭粨鏋 id name value 1 a pp 3 b iii 4 b pp 6 c pp 8 c iii 鏂规硶1 ...
绛旓細鍥炵瓟锛氬彲浠ュ瀵瑰鍚,浣嗗瀵瑰鍏崇郴鍏跺疄鏄繖鏍峰缓绔嬬殑:琛1鈫琛2(澶氬涓)鈫掕〃3(涓瀵瑰)浠庤屽舰鎴愪簡琛1涓庤〃3涔嬮棿鐨勫瀵瑰鍏崇郴銆
绛旓細鎮ㄧ殑鎰忔濇槸B琛ㄤ腑C鐨勫艰鍜孉琛ㄤ腑涓鏍凤紝鎵嶆妸A琛ㄤ腑瀵瑰簲鐨勮褰曡緭鍏琛ㄥ悧锛焥elect A, B, A琛.C, D, E, F, G into C琛 from A琛 inner join B琛 on A琛.C=B琛.C
绛旓細鏄/鍚︺傝繖绉嶅瓧娈垫槸閽堝浜庢煇涓瀛楁涓彧鍖呭惈涓や釜涓嶅悓鐨勫彲閫夊艰岃绔嬬殑瀛楁锛岄氳繃鏄/鍚︽暟鎹被鍨嬬殑鏍煎紡鐗规э紝鐢ㄦ埛鍙互瀵规槸/鍚﹀瓧娈佃繘琛岄夋嫨銆鍦ㄨ〃鐨勮璁¤鍥句腑锛屾瘡涓涓瓧娈甸兘鏈夎璁$被鍨嬶紝Access鍏佽涔濈鏁版嵁绫诲瀷锛氭枃鏈佸娉ㄣ佹暟鍊笺佹棩鏈/鏃堕棿銆佽揣甯併佽嚜鍔ㄧ紪鍙枫佹槸/鍚︺丱LE瀵硅薄銆佽秴绾ч摼鎺ャ佹煡璇㈠悜瀵笺
绛旓細鐐瑰嚮鑿滃崟鏍忎笂闈㈢殑锛氬垱寤衡斺旀煡璇㈣璁★紱鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑閫夋嫨涓や釜琛細璁㈠崟鍜岃鍗曟槑缁嗭紝鐒跺悗鐐瑰嚮娣诲姞锛涙坊鍔犱笅鍒楀瓧娈靛埌璁捐琛ㄤ腑锛涚偣鍑昏彍鍗曟爮涓婇潰鐨勪繚瀛樻寜閽紱鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑锛岃緭鍏ヨ繖涓煡璇㈢殑鍚嶅瓧锛岀劧鍚庣偣鍑荤‘瀹氬嵆鍙
绛旓細涓婚敭瀛楁鍏锋湁鍞竴鎬,璁剧疆涓や釜鎴栦袱涓互涓婂瓧娈典负涓婚敭鍏锋湁鏇村ぇ鐨勭伒娲绘,浣挎暟鎹簱鎿嶄綔鏇村鏄.姣斿璇,涓涓姳鍚嶅唽琛,鏈濮撳悕,鎬у埆,鍑虹敓鏃ユ湡绛夊瓧娈,濡傛灉鍙濮撳悕涓轰富閿,閭d箞閬囧埌鍚屽悕鍚屽鐨勫氨涓嶅ソ澶勭悊浜,鑰屽皢濮撳悕,鎬у埆,鍑虹敓鏃ユ湡鍧囪涓轰富閿,鍐嶉亣鍒板悓濮撳悕鐨勫氨娌¢棶棰樹簡,闄ら潪浠栦滑杩炴у埆,鍑虹敓鏃ユ湡涔熼兘鐩稿悓,褰撶劧鐩存帴...