我正在尝试选择所有城市分支机构都有账户的人。
(使用SQL查询)
现在我收到如下错误信息:
谢谢您的帮助。
SELECT A.customId
FROM accountholder as A
WHERE NOT EXISTS (
(SELECT name
FROM branch
WHERE city='LA')
EXCEPT (SELECT C.branch
FROM accountholder AS B, account AS C
WHERE B.accountnumber = C.accountnumber
AND A.customId = B.customId));
现在我收到如下错误信息:
但是我不知道问题出在哪里。是我太糊涂了还是哪里出了问题?ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXCEPT (SELECT C.branch FROM accountholder AS B, account AS C WHERE B.accountnumber=' at line 1
谢谢您的帮助。
EXCEPT
运算符? - user330315