UPDATE A
SET
get_num = B.fssum
FROM
pdorders A,
(select orderid,fssum=sum(fssum) from pdorder_caigou group by orderid) B
WHERE
A.id = B.orderid
SET
get_num = B.fssum
FROM
pdorders A,
(select orderid,fssum=sum(fssum) from pdorder_caigou group by orderid) B
WHERE
A.id = B.orderid
SET get_num = T.fssum
FROM
(select sum(fssum) as fssum from pdorders A, pdorder_caigou B
WHERE A.id = B.orderid
) T
SET get_num = get_num
from
(
select orderid,SUM(fssum) get_num from pdorder_caigou B
group by orderid
)b,pdorders A
WHERE A.id = B.orderid
SET A.get_num =b.fssum
FROM pdorders A, (select orderid,sum(fssum) as fssum from pdorder_caigou group by orderid) B
WHERE A.id = B.orderid
set get_num = b.fssum
from pdorders a inner join
(select orderid,sum(fssum) as fssum from pdorder_caigou group by orderid) b
on a.id = b.orderid