INSERT INTO agents
(agent_code,
 description,
 site_id,
 last_user,
 archive_flag)
SELECT 'ULTRA',
       'Tagtrak Internal - not for general use',
       site_id,
       1,
       0
FROM site_info
WHERE airport_code = 'XXX';

COMMIT;
