SELECT DISTINCT qr.plan_id, qp.name, qr.collection_id from qa_results qr, qa_plans qp where qr.plan_id = qp.plan_id and occurrence not in (select child_occurrence from qa_pc_results_relationship)
View Text - HTML Formatted
SELECT DISTINCT QR.PLAN_ID , QP.NAME , QR.COLLECTION_ID FROM QA_RESULTS QR , QA_PLANS QP WHERE QR.PLAN_ID = QP.PLAN_ID AND OCCURRENCE NOT IN (SELECT CHILD_OCCURRENCE FROM QA_PC_RESULTS_RELATIONSHIP)