Hi folks, I've searched for this answer, but haven't been able to find anything. Does query of query not support aliasing? If I try to do either a table or a column alias, I get an error: <cfquery name="trythis" dbtype="query"> SELECT a.shortdate, a.totalmilkavg as youravg, b.totalmilkavg as allavg FROM myresults a, myresults b WHERE b.shortdate = a.shortdate AND a.yours = 1 AND b.yours = 0 </cfquery> This is the error I get: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag If I do a version that eliminates the self-join and the column alias, it works just fine. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
