因为该列没有包含在聚合函数或 GROUP BY 子句中

[房磊]

select stuName,ExamNo, LabExam from stuMarks, stuInfo where dbo.stuInfo.stuNo =stuMarks.stuNo group by dbo.stuInfo.stuName

[--小F--]

select
 stuName,ExamNo, LabExam 
from
 stuMarks, stuInfo 
where
 dbo.stuInfo.stuNo =stuMarks.stuNo 
group by
 stuName,ExamNo, LabExam 

[--小F--]

都没聚合函数 不知道楼主写这个的用意何在

[--小F--]

如果去重,还可以用distinct

[chuanzhang5687]

select stuName,ExamNo, LabExam from stuMarks, stuInfo 
where dbo.stuInfo.stuNo =stuMarks.stuNo group by dbo.stuInfo.stuName,ExamNo, LabExam 

[-晴天]

select stuName,ExamNo, LabExam from stuMarks, stuInfo where dbo.stuInfo.stuNo =stuMarks.stuNo 

[-晴天]

or

select distinct stuName,ExamNo,LabExam from stuMarks,stuInfo where dbo.stuInfo.stuNo=stuMarks.stuNo 

[老潘]

不带聚合函数的GROUP BY可用DISTINCT替代，更简单

[房磊]

[Quote=引用 3 楼 fredrickhu 的回复:]
如果去重,还可以用distinct
[/Quote]
谢了！