TransWikia.com

MS Access Syntax Error (Missing Operator) in query expression NOT EXISTS

Stack Overflow Asked by WaterHearts on January 19, 2021

I am currently working in MS Access and are coming across this error when I got to execute my query. "Syntax Error (Missing Operator) in query expression NOT EXISTS"

This is the query that is generating this error:

SELECT fName, lName, SSN
FROM Employee
WHERE NOT EXISTS
((SELECT storeID 
FROM Store
WHERE storeID = 3) 
EXCEPT
(SELECT orderID
FROM Works_On
WHERE  Employee.SSN = Works_On.SSN));

I have double checked spelling, syntax, and where I have my spaces and but I can’t figure out what is causing this error, research online has also failed me as well.

The results I want to achieve is having the name and SSN of all employees who work on an order who are from store 3.

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP