INSERT INTO location_group(NAME,DESCRIPTION,SITE_ID,LAST_USER,ARCHIVE_FLAG) SELECT 'L', 'LOCAL', site_id, 1, 0 FROM site_info WHERE airport_code='XXX';
INSERT INTO location_group(NAME,DESCRIPTION,SITE_ID,LAST_USER,ARCHIVE_FLAG) SELECT 'T', 'TRANSFER', site_id, 1, 0 FROM site_info WHERE airport_code='XXX';
COMMIT;
