Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sturner333
Starting Member
22 Posts |
 Posted - 2014-10-06 : 08:48:47
|
| 'Column is invalid in the select list because it is not contained in either an aggregate function or the group by clause.'The columns I get the error on I just want the data from in my query.Thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-06 : 09:31:04
|
| the error message means what it says. Either the column in question needs to be aggregated (e..g. sum, max, avg) or it needs to be in the group by clause. Choose the one that makes the most sense.btw, you really should post your whole query, not just the error message. |
 |
|
|
sturner333
Starting Member
22 Posts |
Posted - 2014-10-06 : 09:57:36
|
| the exact query was not relevent in this case. thanks for the reply |
|
|
|
|
|
|
aggregate error