SHARE
TWEET

Untitled

a guest Jun 25th, 2019 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT 'UPDATE p_information SET admin_entitiy_id ='||asa.id||' where pi.id
  2. ='||PI.id||';'
  3. FROM
  4. p_information pi
  5. LEFT JOIN admin_setup_accounts asa ON asa.name = pi.admin_entity_unverified
  6. WHERE
  7. pi.admin_entity_unverified IS NOT NULL
  8. AND pi.admin_entity_unverified <> ''
  9. AND pi.admin_auditing_entity_id IS NULL
  10. and pi.id < 200000
  11. AND pi.admin_entity_unverified IN (select name  FROM admin_setup_accounts)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top