JRS 6.0.2 allows me to report on Test Case Execution Records and trace them to Test Suites.  This generates the following SQL:

SELECT DISTINCT T1.PROJECT_NAME,

       T1.REFERENCE_ID,

       T1.NAME AS URL1_title,

       T1.URL AS URL1,

       T2.REFERENCE_ID AS REFERENCE_ID1,

       T2.NAME AS URL2_title,

       T2.URL AS URL2

FROM RIDW.VW_EXECUTION_WORKITEM T1

INNER JOIN RIDW.VW_TESTPLAN T2

ON (T2.TESTPLAN_ID = T1.TESTPLAN_ID)

INNER JOIN RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP LT1

ON (T1.EXECWORKITEM_ID = LT1.EXECWORKITEM_ID)

  INNER JOIN RIDW.VW_TESTSUITE T3

  ON (T3.TESTSUITE_ID = LT1.TESTSUITE_ID)

WHERE T3.PROJECT_ID = 30 AND T2.PROJECT_ID = 30 AND

  T1.PROJECT_ID = 30  AND

(T1.ISSOFTDELETED = 0 AND T2.ISSOFTDELETED = 0) AND

(T1.EXECWORKITEM_ID <> -1 AND T1.EXECWORKITEM_ID IS NOT NULL) AND

(T2.TESTPLAN_ID <> -1 AND T2.TESTPLAN_ID IS NOT NULL)