Quote:
UPDATE orders
SET orders.orders_status='16'
where purchase_items.purchase_orders_id='NULL'
|
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".