Subversion Repositories DevTools

SELECT *
  FROM
       (
        
           SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db, 
                  si.dbid AS iss_id, 
                          si.new_num AS iss_num, 
                          si.headline AS summary, 
                          sdef.name AS status, 
                          si.priority AS priority,
                          si.releaseinfo as releaseinfo,
                  si.issue_type AS issue_type, 
                          si.release_part1, 
                          si.release_part2, 
                          si.release_part3, 
                          si.project, 
                          si.product, 
                          si.package_ref, 
                          si.notes_log, 
                  si.description, 
                          NULL AS release_id, 
                          NULL AS client_ref, 
                          NULL AS severity, 
                          NULL AS cr_internal, 
                          NULL AS cr_external, 
                          sp.fullname AS submitter, 
                  si.submit_date, 
                          ow.fullname AS owner, 
                          ap.fullname AS approver
             FROM DEVI_PROD.admin.software_issue si INNER JOIN
                  DEVI_PROD.admin.statedef sdef ON si.state = sdef.id INNER JOIN
                  DEVI_PROD.admin.users sp ON si.submitter = sp.dbid INNER JOIN
                  DEVI_PROD.admin.users ow ON si.owner = ow.dbid INNER JOIN
                  DEVI_PROD.admin.users ap ON si.approver = ap.dbid
                WHERE si.dbid IN (/*DEVIiss*/)
                
                UNION ALL
                
           SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db, 
                          si.dbid AS iss_id, 
                          si.job_number AS iss_num, 
                          si.problem_summary AS summary, 
                          sdef.name AS status, 
                          si.priority AS priority, 
                          NULL AS releaseinfo,
                          NULL AS issue_type, 
                          NULL AS release_part1, 
                          NULL AS release_part2, 
                          NULL AS release_part3, 
                          si.group_project AS project, 
                  si.category_main AS product, 
                          NULL AS package_ref, 
                          si.notes_log, 
                          si.description, 
                          si.release_id, 
                          si.client_ref, 
                          si.severity, 
                  si.change_request AS cr_internal, 
                          si.external_change_request AS cr_external, 
                          sp.fullname AS submitter, 
                          si.when_reported AS submit_date, 
                  ow.fullname AS owner, 
                          ap.fullname AS approver
                 FROM TDSE_2002.admin.request si INNER JOIN
                  TDSE_2002.admin.statedef sdef ON si.state = sdef.id INNER JOIN
                  TDSE_2002.admin.users ow ON si.owner = ow.dbid INNER JOIN
                  TDSE_2002.admin.users sp ON si.raised_by = sp.dbid INNER JOIN
                  TDSE_2002.admin.users ap ON si.who_reported = ap.dbid
                WHERE si.dbid IN (/*TDSEiss*/)
        
        
        ) AS issues
ORDER BY iss_num ASC