Re: summing values

2006-06-30 Thread Peter Brawley
Since one person can be listed in both 1 and 2 in each section (just not in the same row) I need to sum up that person's votes between the two columns. I've tried summing two subqueries but it errors out because of returning two values. Unclear. Where is a user's 1 or 2 recorded? What is a

RE: summing values

2006-06-30 Thread Mazur Worden, Kathy
PROTECTED] Sent: Friday, June 30, 2006 10:45 AM To: Mazur Worden, Kathy Cc: mysql@lists.mysql.com Subject: Re: summing values Since one person can be listed in both 1 and 2 in each section (just not in the same row) I need to sum up that person's votes between the two columns.  I've tried summing