How to search a test by Run Name in QC 10?

Answer: From the RUN table you can retrieve the TestCycleID (TestInstanceID), the CycleID(TestSetID) and also the TestID(Test of TestPlan ID). So you can get all you want.

Something like this:

SELECT TS_NAME FROM TEST t, RUN r
where t.TS_TEST_ID = r.RN_TEST_ID and r.RN_RUN_NAME LIKE 'Run_xxxxx'