UPDATE ecs_goods JOIN ecs_jr_zseb_zkcsd ON ecs_goods.goods_sn = ecs_jr_zseb_zkcsd.matnr SET ecs_goods.xinghao =ecs_jr_zseb_zkcsd.maktx WHERE ecs_goods.xinghao = ''