masoud.a
پنج شنبه 22 اردیبهشت 1390, 00:21 صبح
ميشه يكي كمكم كنه بگه اين Error واسه چيه؟
Column 'student.StdNo' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
اون قسمت از كدي كه داره اين ايراد رو ميگيره اينه:
select student.stdno,student.lname,student.fname,avg(grad e) as 'Average'
from student inner join register on student.stdno=register.stdno
group by student.stdno
having avg(grade)>12
Column 'student.StdNo' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
اون قسمت از كدي كه داره اين ايراد رو ميگيره اينه:
select student.stdno,student.lname,student.fname,avg(grad e) as 'Average'
from student inner join register on student.stdno=register.stdno
group by student.stdno
having avg(grade)>12