Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
please help me , select from 2 table with a function column
nofact noface
Jun 14 2015 7:45 AM
369
Reply
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 me
I am in trouble
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Is it possible to convert multiple rows to a single column?
Microsoft SQL Server, Error:53