SELECT 'UPDATE p_information SET admin_entitiy_id ='||asa.id||' where pi.id
='||PI.id||';'
FROM
p_information pi
LEFT JOIN admin_setup_accounts asa ON asa.name = pi.admin_entity_unverified
WHERE
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)