Someone who knows SQL is here to help!

update ecs_goods_gallery set img_original=ecs_ from ecs_goods_gallery join ecs_goods on ecs_goods_

If it's mssqlserver, it should be like this, and it's best to state your database and the corresponding version. My writing method above should be the writing of standard SQL statements, and the general database should support it, if it doesn't work again, you may have to check whether there will be a problem with the data in your table, and, after you connect, do you have to do other operations, if so, will it be a problem with your conditions.

updata ecs_goods_gallery

set ecs_goods_gallery .img_original =ecs_

where ecs_goods_gallery .goods_id=ecs_

This one is usually used. But the prompt doesn't match the alias.

The landlord adds the from keyword to match. Namely.

updata ecs_goods_gallery

set ecs_goods_gallery .img_original =ecs_

from ecs_goods_gallery,ecs_goods

where ecs_goods_gallery .goods_id=ecs_

update a set = from ecs_goods_gallery a,ecs_goods b where =

sql server2000

Try to see if you can achieve the effect you want...

I interviewed for this statement in SQL Server 2000 myself. It can be achieved. If you're not a SQL Server 2000 database, you probably can't.

I can't help it...

Fairly simple.

update ecs_goods_galleryset img_original=

from ecs_goods_gallery a ,ecs_goods b

The sentence form of the statement wherefrom ecs goods gallery A and ecs goods b cannot be changed, and the ECS goods gallery must be put in front.

update ecs_goods_gallery set ecs_goods_

from ecs_goods_gallery,ecs_goodswhere ecs_goods_

Try this again I ran and it was definitely right.

update ecs goods galleryset ecs goods = ecs from ecs goods gallery inner joinecs goods on ecs goods = ecs Notice if there are constraints such as not being nullable.