Damon, EID defines a "grouping", and SUM defines an aggregate calculation for each distinct value in the grouping. When you combine a column like EID with an aggregate calculation like SUM, you must also have a GROUP BY in your select. And it will always be the list of all the columns that are not within aggregate expressions.
Select pr.EID, Sum(pr.GROSSPAY) From PRHIST pr, ESOP eh Where pr.EID = eh.EID Group by pr.EID Bill On Fri, Nov 21, 2008 at 1:50 PM, Gray, Damon <[EMAIL PROTECTED]> wrote: > Select > > pr.EID, Sum(pr.GROSSPAY) > > From > > PRHIST pr, ESOP eh > > Where > > pr.EID = eh.EID > > > > > > > > > > wwwww > > ( @ @ ) > > -------oOO---(_)---OOo------- > > Damon J. Gray > > Anvil Corporation Business Services > > (360) 937-0770 > > oooo0 0oooo > > ( ) ( ) > > ----------\ (----) /----------- > > \__) (__/ > > >
