如果楼上的不能运行请这样:update t_1 set goods_name=b.goods_name from t_1 a,t_2 b where a.goods_id=b.goods_id
update t_1 set a.goods_name=b.goods_name from t_1 ,t_2 where t_1.goods_id=t_2.goods_id
错了 --不用别名 update t_1 set t_1.goods_name=t_2.oods_name from t_1 ,t_2 where t_1.goods_id=t_2goods_id--用别名 update a set a.goods_name=b.goods_name from t_1 a,t_2 b where a.goods_id=b.goods_id
--今天这是怎么了啊,老写错。少了个点,还少给了个g --不用别名 update t_1 set t_1.goods_name=t_2.goods_name from t_1 ,t_2 where t_1.goods_id=t_2.goods_id
from t_1 a,t_2 b
where a.goods_id=b.goods_id
update t_1 set a.goods_name=b.goods_name from t_1 ,t_2 where t_1.goods_id=t_2.goods_id
--不用别名
update t_1 set t_1.goods_name=t_2.oods_name from t_1 ,t_2 where t_1.goods_id=t_2goods_id--用别名
update a set a.goods_name=b.goods_name from t_1 a,t_2 b where a.goods_id=b.goods_id
--不用别名
update t_1 set t_1.goods_name=t_2.goods_name from t_1 ,t_2 where t_1.goods_id=t_2.goods_id