Embedded SELECT

[Kem Tekinay]

Shouldn¹t this code work?

select tbl.repname as 'name', tbl.majorparty as 'party', sum(tbl.v) from (
select
 votes as 'v', if(party='dem' or party='gop', name, 'other') as 'repname',
 if(party='dem' or party='gop', party, '---') as 'majorparty' from
Candidates ) tbl group by tbl.repname, tbl.majorparty
__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
http://www.mactechnologies.com                        Pager (917) 491-5546

  To join the MacTechnologies Consulting mailing list, send an e-mail to:
           mactechnologies_consulting-subscribe at yahoogroups.com