Submitted by pwadmin on Tue, 2015-03-17 15:47
Some organizations have more than one membership record. Move the old payment records from the inactive membership to the active one, so that the active one has a full history. Make sure the join, start, and end dates are correct. Then delete the inactive membership.
This sql is for moving the payments to the current membership.
update pillar_civi_new.civicrm_membership_payment set membership_id=1291 where membership_id = 1114;