Delete Query with two joins to a Query

[ry94080]

Hi all,

I'm trying to create a DELETE query with a table that has two joins to a Query. Is this possible?

This is what I have so far but is not working.

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

Any ideas welcomed