So you want : (13 + 192) / 2? Or do you need 192/13 ? On Thu, Mar 10, 2011 at 2:07 PM, Torrent Girl <moniqueb...@gmail.com> wrote:
> > >can you provide a couple rows of data with no functions? just the ad.acd > and > >the da.connects? > >and what you would like for it to show? whenever you use an aggregate > >function like avg you have to use group by > >like > > > >select studentId, avg(grade) > >from grades > >group by studentId > > > > > > > >On Thu, Mar 10, 2011 at 1:52 PM, Torrent Girl <moniqueb...@gmail.com> > wrote: > > > >> > Do you mean let you see the returned data? > > Here is my query (there is a group by) :) > > SELECT da.connects, sum(ad.acd) as acd FROM dialeragent da, agentDaily ad > WHERE da.employeeID = ? AND da.employeeID = ad.employeeID AND da.dateWorked > = ? AND ad.dateWorked = ? group by connects > > here is what it returns. > > ACD CONNECTS > 13 192 > > I need to total the AVG of these two numbers. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm