hi all, need some urgent help. I am no phpmyadmin guru so I guess it may be very easy for you. On a magento database I need to update sales_flat_order volumn customer_group_id where the customer_group_id = 0 and I want it to update the value from another table: take it from table customer_entity and column name is group_id so in short: i want to do this: UPDATE sales_flat_order column "customer_group_id" where "customer_group_id" = 0 and the new value of "customer_group_id" should be from "customer_entity" field "group_id" What to enter in phpmyadmin SQL ? thanks a lot for any help
this code did the job Code: update sales_flat_order sfo join customer_entity ce on ce.entity_id = sfo.customer_id set sfo.customer_group_id = ce.group_id where sfo.customer_group_id=0