在一個表中錄入一個資料。如A表:order_no ,qty B表:bill , qty
20js0501 500 20js0501 0
如何實作當A.order_no=B.bill 時。B.qty=A.qty
uj5u.com熱心網友回復:
conn.execute " UPDATE B SET B.qty=A.qty FROM B INNER JOIN A ON B.bill=A.order_no "uj5u.com熱心網友回復:
conn.execute"update b set b.qty=a.qty where a.order_no=b.bill"jion用不來, 試試這個
為何不把order和bill兩個欄位名統一一下.
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/150534.html
標籤:VB基礎類
