>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 <[email protected]> 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:342906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
