Updating with a JOIN

Asked Oct 13 '14 at 08:03

Active Oct 13 '14 at 08:18

Viewed 77 times

how do i fix my query? I need to update my table to add inventory to the inventory table which is different from the order table

currently here is my query.

$qry = "UPDATE inventory 
        SET inventory.prod_quantity = inventory.prod_quantity + order_detail.quantity
        FROM inventory
        RIGHT JOIN order_detail on inventory.id=order_detail.orderid 
        WHERE inventory.id='{$_REQUEST['productid']}' ";

but it doesnt work. I dont know if i did it wrong or something. it wont add and i think my query format is wrong, im new with joins so an explanation would be nice.

productid is the same as id in inventory table.

Thank you.

edited Oct 13 '14 at 08:18

asked Oct 13 '14 at 08:03

geds13

Can you elaborate on "it doesn't work"? Are you getting an error? The wrong results? – Mureinik Oct 13 '14 at 08:06
@Mureinik it doesnt add. – geds13 Oct 13 '14 at 08:14
UPDATE inventory RIGHT JOIN order_detail on inventory.id=order_detail.orderid SET inventory.prod_quantity = inventory.prod_quantity + order_detail.quantity WHERE inventory.id='{$_REQUEST['productid']}' "; – Prasanth V J Oct 13 '14 at 08:19
@PrasanthVJ it still didnt work. – geds13 Oct 13 '14 at 08:30

Updating with a JOIN

0 Answers0