The query below will get a list of the tests that haven't been pulled from Test Plan over into the Test Lab module. You may need to tweak it some to fit your needs.

SELECT TS_TEST_ID As 'Test ID', TS_NAME As 'Test Name', TS_RESPONSIBLE As 'Testers Name'
FROM TEST
LEFT OUTER JOIN TESTCYCL
ON (TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID)
WHERE TESTCYCL.TC_TEST_ID IS NULL