我搞错了-
专栏的员工.EmpID在 Select 列表中无效,因为它是
select loc.LocationID, emp.EmpID
from Employee as emp full join Location as loc
on emp.LocationID = loc.LocationID
group by loc.LocationID
这种情况符合比尔·卡温给出的答案.
修正上述内容,符合ExactaBox的回答-
select loc.LocationID, count(emp.EmpID) -- not count(*), don't want to count nulls
from Employee as emp full join Location as loc
on emp.LocationID = loc.LocationID
group by loc.LocationID
ORIGINAL QUESTION -
对于SQL查询-
select *
from Employee as emp full join Location as loc
on emp.LocationID = loc.LocationID
group by (loc.LocationID)
我不明白为什么我会犯这个错误.我所要做的就是将这些表连接起来,然后将特定位置的所有员工分组在一起.
I think I have a partial explanation for my own question. Tell me if its ok -
要将在同一地点工作的所有员工分组,我们必须首先提到LocationID.
那么,我们不能/不提它旁边的每个员工ID.相反,我们提到的是该地点的员工总数.我不确定,我们为什么要用后一种方式.
错误的100条款部分的解释是什么?