GROUP BY

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Start with this:

select

rightt.*,

leftt.*

FROM

#temp2 leftt

left outer join #temp1 rightt

on rightt.EmployeeID = leftt.EmpID

GROUP BY

leftt.EmpID

Some changes I'd make would be to explicitly identify the columns being returned. Also, are you aggregating any of the fields?

😎

Mike Levan SSChampion Points: 14201 More actions · Answer 2

NO, tht will not do.

it gives error for many columns

Column '#temp2.EmpIDis invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

A GROUP BY assumes you are aggregating some data in your select statement. That was the question I also asked in my previous post.

Now my question is, what are you trying to accomplish with this query?

😎

Mike Levan SSChampion Points: 14201 More actions · Answer 4

both temp tables already has some aggregated values in that, now am trying to group them by empid.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

I am going to need more to help you out. Please read this article, it will show you how to help up help you:

😎