Chefao
Member
- Apr 30, 2017
- 45
- 27
Hello
my hotel contains many rare
and I wanted to leave all of them with allow_trade 0 from another table (catalog_items)
tables: furniture and catalog_items
I want the allow_trade to stay 0 from catalog_items
I tried this:
SELECT item_id
FROM catalog_items
INNER JOIN furniture ON catalog_items.item_id = furniture.allow_trade
UPDATE db.furniture SET allow_trade = '0' WHERE catalog_items.item_id = 915
Can someone help me?
my hotel contains many rare
and I wanted to leave all of them with allow_trade 0 from another table (catalog_items)
tables: furniture and catalog_items
I want the allow_trade to stay 0 from catalog_items
I tried this:
SELECT item_id
FROM catalog_items
INNER JOIN furniture ON catalog_items.item_id = furniture.allow_trade
UPDATE db.furniture SET allow_trade = '0' WHERE catalog_items.item_id = 915
Can someone help me?
Last edited: