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: > > >Shouldn't it be? > > > >SELECT avg(da.connects+ sum(ad.acd)) as averageTotalCalls > > > > > > I changed it and still got the same error: > > Invalid use of group function > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
