a guest Jun 25th, 2019 45 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT 'UPDATE p_information SET admin_entitiy_id ='||asa.id||' where pi.id
- p_information pi
- LEFT JOIN admin_setup_accounts asa ON asa.name = pi.admin_entity_unverified
- pi.admin_entity_unverified IS NOT NULL
- AND pi.admin_entity_unverified <> ''
- AND pi.admin_auditing_entity_id IS NULL
- and pi.id < 200000
- AND pi.admin_entity_unverified IN (select name FROM admin_setup_accounts)
RAW Paste Data