把对应表的字段跨表赋值

UPDATE MultiCompany.Finance.FwDocs
SET Quantity=aa.q,DocNo='FPDD'+ right(replicate('0',8-LEN(ID))+ltrim(ID),8)
FROM (SELECT SUM(Quantity) q,DocId dd FROM MultiCompany.Finance.FwDocDetails GROUP BY DocId) aa
WHERE Finance.FwDocs.Id=aa.dd
posted @ 2013-07-15 14:35  毛丹  阅读(231)  评论(0)  编辑  收藏  举报