On Mon, Jun 15, 2009 at 4:56 PM, Arsalan Tariq Keen wrote: > <cfquery name="sites_data" datasource="data"> > SELECT id, site, far_end, site_type, phase, lat, long, cluster AS > clust, city, region, sites_status > FROM sites
> ORDER BY region > </cfquery> > > > now if I add 'GROUP BY clust' then it gives an error. Don't forget that every column that is in your SELECT list should either be an aggregate statement or should be in the list of columns in the GROUP BY. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
