Inputting A data in A table, such as A table: order_no, qty table B: bill, qty
20 js0501 500 20 js0501 0
How to implement when A.o rder_no=B.b ill, B.q ty=A.q ty

CodePudding user response:

Conn. Execute "UPDATE B SET B.q ty=A.q ty the FROM B INNER JOIN A ON B.b ill=A.o rder_no"

CodePudding user response:

Conn. Execute "update b set b.q ty=a.q ty the where a.o rder_no=b.b ill"

Jion in not to try this

Why don't you put the order and bill two unified field name.