I think I just figured this out via this query:


DELETE *FROM LV_TEST_UNQ
WHERE EXISTS
    (SELECT *
      FROM vMST_Max_NotLV
      WHERE vMST_Max_NotLV.AccessionNumber = LV_TEST_UNQ.AccNo)
AND EXISTS
    (SELECT *
      FROM vMST_Max_NotLV
      WHERE vMST_Max_NotLV.OrderCodes = LV_TEST_UNQ.TestCode);