I am trying to use a subquery to define a list to delete. The purpose of this code is to delete duplicates in tblAmazonOrderInput2.
Both queries have the same syntax error: Syntax error in query expression: 'EXISTS (SELECT * FROM qryAmazonOrderInput-Dedupe WHERE qryAmazonOrderInput-Dedupe.ID = tblAmazonOrderInput2.ID)'
Code:
DELETE tblAmazonOrderInput2.*
FROM tblAmazonOrderInput2
WHERE EXISTS (SELECT * FROM qryAmazonOrderInput-Dedupe WHERE qryAmazonOrderInput-Dedupe.ID = tblAmazonOrderInput2.ID);
Code:
SELECT tblAmazonOrderInput2.*
FROM tblAmazonOrderInput2
WHERE EXISTS (SELECT * FROM qryAmazonOrderInput-Dedupe WHERE qryAmazonOrderInput-Dedupe.ID = tblAmazonOrderInput2.ID);