mkx

I need to update orders_status from the orders table based on the following info and table structure. As you can see I have very little clue what I am doing or how to explain this but hopefully someone can make sense of what I am asking for. Will paypal $20 or send the equivalent in bitcoin for the first complete working sql query.

UPDATE orders
SET orders.orders_status='16'
where purchase_items.purchase_orders_id='NULL'


table = purchase_items

purchase_items_id=4839
orders_products_items_id=4761

table = orders_products_items

orders_products_items_id=4761
orders_products_id=3579

table = orders_products

orders_products_id=3579
orders_id=30920

table = orders

orders_id=30920
orders_status=2