RE: summing values

2006-06-30 Thread Mazur Worden, Kathy
[mailto:[EMAIL 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

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 i