hello every one
I have 2 table
1-id,name,family
2-id,score
and want to select command below but sql server take me error
select member.id,member.name,member.family,sum(activity.score) from member inner join activity on member.id=activity.mem_id
and error Msg 8120, Level 16, State 1, Line 1
Column 'member.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
please help meI am in trouble
Manoj BhoirPosted Jun 14, 2015, 8:14 AM
from member inner join activity on member.id=activity.id
Group by member.id,member.name,member.family
Manoj BhoirPosted Jun 14, 2015, 8:38 AM
nofact nofacePosted Jun 14, 2015, 8:36 AM