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);