Code:
SELECT MIN(TableName) as TableName   
            , ID   
            , COL1   
            , COL2   
            , COL3   
FROM    
(    
     SELECT 'Table I' as TableName   
                  , A.ID   
                  , A.COL1   
                  , A.COL2   
                  , A.COL3   
     FROM creator1.tablename A    
     UNION ALL    
     SELECT
...