Sorry, not sure if I have explained it in the best way possible... We have around 2500 orders, where customers did not get their loyalty points validated - we need to edit the database table with mass query, so orders, which have status "shipped", would get their points validated. Problem is, that order status is in one table, while point status/validity is set in another table.
I've tried using this code, but no luck:
UPDATE ps_loyalty SET id_loyalty_state = '2', WHERE ps_orders.id_order = ps_loyalty.id_order AND ps_orders.current_state = '4'
As I've said, I don't know sql programming language, thus not sure how to set the query right. Any help would be greatly appreciated..!