$20 paypal or bitcoin for help with sql statement
 

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

Bud, I'm sure there's purchase ID and other variables if you try to link two tables. For those of us who went to college its called "unique identifier".

icq me: 33375924 or woj#at#wojfun#.#com :thumbsup

what ^^ said.

Hit me on icq , I will give an ans , but i need more info

Looks perty straight forward update statement

674227838