[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
>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
I'd like to sum up values from two different columns in one table that
is constructed like this:
CREATE TABLE `nominations`
( `id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`SectionA_Nominee1` varchar(255) NOT NULL default 'n/a',
`SectionA_Nominee2`
