Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `person_attribute`, `person_address` SET `person_address`.`address2` = `person_attribute`.`value`, `person_attribute`.`voided` = 1, `person_attribute`.`voided_by` = 1, `person_attribute`.`date_voided` = NOW(), `person_attribute`.`void_reason` = "merged to address2 field", `person_address`.`changed_by` = 1, `person_address`.`date_changed` = NOW() WHERE `person_attribute_type_id` = 14 AND `person_attribute`.`voided` = 0 AND `person_address`.`voided` = 0 AND `person_attribute`.`person_id` = `person_address`.`person_id` AND `address2` IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement