Subversion Repositories DevTools

/* SDKs Referenced by the Release */

select distinct 

    sn.SDK_NAME, 

    st.SDKTAG_NAME, 

    rc.SDKTAG_ID

from RELEASE_CONTENT rc, 

     SDK_NAMES sn, 

     SDK_TAGS st

WHERE rc.RTAG_ID = :RTAG_ID

  AND st.SDKTAG_ID = rc.SDKTAG_ID

  AND sn.SDK_ID = st.SDK_ID

ORDER BY UPPER(sn.SDK_NAME), UPPER(st.SDKTAG_NAME)