把一张表的字段更新到另外一张表

update lps_trade_deal d set goods_name=(select goods_name from lps_goods g where g.goods_code=d.goods_code) where d.id>0;