How to update a column with another tables columns value? [duplicate]

Question

I have two tables "basket_products" and "products". I want to update "products" table's "adet" column with "basket_products" "adet" column. And i want to update rows where basket_products.urun = products.urun. I want to use this code and getting error : "The multi-part identifier "basket_products.urun" could not be bound."

update products
    set adet = adet - (
        select basket_products.adet
            from basket_products
                inner join products
               on products.urun = basket_products.urun) 
   where products.urun = basket_products.urun

What's wrong?

Thank you. ı could not find topic.

iosonobg
– iosonobg

2013-12-31 00:22:12 +00:00
Commented Dec 31, 2013 at 0:22 — iosonobg
– iosonobg, Commented Dec 31, 2013 at 0:22

POK · Accepted Answer · 2013-12-31 00:27:07Z

2

Try this:

update p set p.adet = bp.adet from products p join basket_products bp on p.urun = bp.urun

answered Dec 31, 2013 at 0:27

POK

843 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update a column with another tables columns value? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related