TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
nofact noface
NA
15
1.6k
please help me , select from 2 table with a function column
Jun 14 2015 7:45 AM
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
Reply
Answers (
3
)
Is it possible to convert multiple rows to a single column?
Microsoft SQL Server, Error:53