On Wed, 21 Feb 2007, Igor Tandetnik wrote:
The query looks good. What's the data in the pos column? Could it be that the average is indeed zero?
Igor, Of course! I was not thinking it completely through and now it's quite clear.
select cat, pos, avg(col1), avg(col2), ... from voting group by cat, pos;
Ah! That's what I was missing at the end of a very long day. Thank you very much. As I wrote, it's been longer than I thought since I wrote SQL to any extent. Time to get a basic SQL book to complement my advanced one by Joe Celko. Many thanks, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
