sqlserver根据某一字段将A表数据update到B表

UPDATE A
SET A.OfficeIndexes = B.ReceiptID
FROM
	RZ_PB_RZMinorInfo A,
	RZ_PB_ChargesPlan B
WHERE
	A.AuthNo = B.AuthNo