UPDATE A SETA.Qty2=A.Qty2+B.qty FROM A where A.InvID=B.InvID
update a set A.Qty2=A.Qty2+B.qty from b where A.InvID=B.InvID
你自己都写好了 update a set a.Qty2=A.Qty2+B.qty from a,b where A.InvID=B.InvID
update a set Qty2=A.Qty2+B.qty from a, b where A.InvID=B.InvID
update A set A.Qty2=A.Qty2+B.qty from A,B where A.InvID=B.InvID
update tbA set a.Qty2=a.Qty2+b.qty from tbA a inner jion tbB b on a.InvId=b.InvID
UPDATE A LEFT JOIN B SET A.Qty2=A.Qty2+B.qty ON A.InvID=B.InvID ??
update a set Qty2=A.Qty2+B.qty from a, b where A.InvID=B.InvID
如果a表一个InvID对应B表多个InvID update a set Qty2=A.Qty2 + isnull((select sum(B.qty) from b where InvID = a.InvID),0) from a
少写了个,B UPDATE A SETA.Qty2=A.Qty2+B.qty FROM A,B where A.InvID=B.InvID 或者用JOIN的写法 UPDATE A SETA.Qty2=A.Qty2+B.qty FROM A INNER JOIN B ON A.InvID=B.InvID 效率应该是一样的
update t set Qty2=(select Qty2+qty from b where InvID=t.InvID) from A t
UPDATE A SETA.Qty2=A.Qty2+B.qty FROM A,b where A.InvID=B.InvID这样不就行了!
FROM A
where A.InvID=B.InvID
A.Qty2=A.Qty2+B.qty
from b
where A.InvID=B.InvID
a
set
a.Qty2=A.Qty2+B.qty
from
a,b
where
A.InvID=B.InvID
set Qty2=A.Qty2+B.qty
from a, b
where A.InvID=B.InvID
update A
set A.Qty2=A.Qty2+B.qty
from A,B
where A.InvID=B.InvID
SET
A.Qty2=A.Qty2+B.qty
ON
A.InvID=B.InvID
??
update a
set Qty2=A.Qty2+B.qty
from a, b
where A.InvID=B.InvID
update a
set Qty2=A.Qty2 + isnull((select sum(B.qty) from b where InvID = a.InvID),0)
from a
UPDATE A SETA.Qty2=A.Qty2+B.qty
FROM A,B
where A.InvID=B.InvID
或者用JOIN的写法
UPDATE A SETA.Qty2=A.Qty2+B.qty
FROM A
INNER JOIN B
ON A.InvID=B.InvID
效率应该是一样的
FROM A,b
where A.InvID=B.InvID这样不就行了!