SQL查询错误(非IN运算符)

Question

我有一个用SQL编写的查询

SELECT E.ID E.name
into #TmpEmplyee
FROM Employee E, Outsourcing O, Student S
WHERE E.ID NOT IN (SELECT ID FROM Student UNION SELECT ID FROM Outsourcing)

我有一个例外：

#1064 - 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 '.name FROM Employee E, Outsourcing O, Student S WHERE E.ID NOT IN (SELECT ID FRO' at line 1

我尝试运行内部查询，它起作用了。我认为问题出在NOT IN运算符上，但我不知道它在哪里。如果能帮上忙，我们将不胜感激！

Answer 1

您需要一个逗号:-)

SELECT E.ID, E.name

Answer 2

缺少逗号：

SELECT E.ID, E.name
           ^--

现在，您正在尝试将E.name定义为E.ID的别名，但是别名中不能有句点。

Answer 3

SELECT E.ID, E.name
into #TmpEmplyee
FROM Employee E, Outsourcing O, Student S
WHERE E.ID NOT IN (SELECT ID FROM Student UNION SELECT ID FROM Outsourcing);

逗号很重要。