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