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.
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP