Subversion Repositories DevTools

SELECT *
  FROM projects
 WHERE proj_id IN 
      (
       SELECT rt.proj_id
         FROM release_metrics rm,
              release_tags rt
        WHERE rm.rtag_id = rt.rtag_id
      )
 ORDER BY UPPER(proj_name) ASC