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
bishoe nb
NA
623
80.2k
not contained in either an aggregate function or the GROUPby
Aug 21 2018 3:20 PM
Msg 8120, Level 16, State 1, Line 1 Column 'Citys.City_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SELECT sum(Member_Info.IDCity), Citys.City_Name FROM Member_Info INNER JOIN Citys ON Member_Info.IDCity = Citys.IDCity GROUP BY Member_Info.IDCity And how can use where
Reply
Answers (
1
)
How to merge columns of two different tables into one table
Many of u faced this problem (SQL) Many To Many Relationship