update dbo.maeel00h , dbo.Sheet1 set dbo.maeel00h.el_size=dbo.Sheet1.规格型号 + ' ' + dbo.Sheet1.工艺 where dbo.Sheet1.物料编码 = dbo.maeel00h.el_no and dbo.Sheet1.工艺 IS NOT NULL
update dbo.maeel00h set dbo.maeel00h.el_size=dbo.Sheet1.规格型号 + ' ' + dbo.Sheet1.工艺 from dbo.Sheet1 where dbo.Sheet1.物料编码 = dbo.maeel00h.el_no and dbo.Sheet1.工艺 IS NOT NULL
或者 update a set a.el_size=b.规格型号 + ' ' + b.工艺 from dbo.maeel00h a, dbo.Sheet1 b where b.物料编码 = a.el_no and b.工艺 IS NOT NULL
update a set a.el_size=b.规格型号 + ' ' + b.工艺 from dbo.maeel00h a, dbo.Sheet1 b where b.物料编码 = a.el_no and b.工艺 IS NOT NULL