[thelist] What's wrong with my query?

Mark envoy at sonic.net
Thu May 17 15:10:58 CDT 2007

select business_name, sum(points_awarded) from the_table
group by business_name
order by business_name

You have to have the business_name in the result set (list of selected
fields) in order to group or order by it.

More information about the thelist mailing list