SQL-多表联结的更新示例

UPDATE B SET B.BZSL = A.SL FROM 
(select
	A.itemno ,
	SUM(bar_singleSL)  SL
from
	ERP_CPGL_BZ_detail_barcode A
INNER JOIN ERP_CPGL_bz_main B
on
	B.djno = A.djno
	and B.djlb = A.djlb
inner join 
xsdd_dzit C on
	A.itemno = C.ItemNo
WHERE
	A.ifendor = 'XXXX'
	AND B.djlb = 'XX'
	and C.xsdd_dzid ='102110110032'
GROUP BY A.itemno 
) A 
INNER JOIN ERP_ORDERFORM_PC B ON A.itemno = B.itemno
where XXXX