Subquery - Syntax Error In Expression

[kagoodwin13]

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

DELETE tblAmazonOrderInput2.*
FROM tblAmazonOrderInput2 
WHERE EXISTS (SELECT * FROM qryAmazonOrderInput-Dedupe WHERE qryAmazonOrderInput-Dedupe.ID = tblAmazonOrderInput2.ID);

SELECT tblAmazonOrderInput2.*
FROM tblAmazonOrderInput2 
WHERE EXISTS (SELECT * FROM qryAmazonOrderInput-Dedupe WHERE qryAmazonOrderInput-Dedupe.ID = tblAmazonOrderInput2.ID);

[pbaldy]

The dash would require the name to be bracketed for starters. I've never used the EXISTS syntax; wouldn't a join work there?

[kagoodwin13]

Brackets on the query name was the problem, thanks for the help!

Solution:

DELETE tblAmazonOrderInput2.*
FROM tblAmazonOrderInput2 
WHERE [ID] IN 
(SELECT ID FROM [qryAmazonOrderInput-Dedupe]);

I had some earlier issues with a join that were frustrating, and decided to go at it from a WHERE clause instead. I'm glad the code works, even though it's not 100% optimized.

[kagoodwin13]

It looks like an underscore is more friendly than a dash/hyphen. I think I'll make that change to save any future developers some headache!

[pbaldy]

Happy to help! Yes, I think anything other than an underscore will require the brackets. Personally I don't like the underscore, but that's probably because I can't type it without stopping and looking.