generate_fix_account_address_owner.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 4 行

select concat('update address set address_owner_type = ''Account'' where address_id = ',address_id,';' )
from address, account
where (address_owner_type is null or address_owner_type = '') and address.address_owner_id = account.account_id;