On 2/22/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
However, I'm stuck on the proper SQL syntax. A nudge in the right direction -- including pointers to the appropriate documentation -- would be much appreciated.
The "rule of thumb" is that anything that appears in the group-by clause can appear directly in the select, while other columns are aggregated in the select. Best example using your particular case is Igor's answer:
select cat, pos, avg(col1), avg(col2), ... from voting group by cat, pos; M. Manese ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
