SQL Server 将一张表的某个字段更新到另一张表中

update t1 set t1.BPTProductId=t2.BPTId
from Bas_ProductImageUrl t1
join Bas_Products t2
on t1.BPTBarCode=t2.BPTBarCode