Sorry I don't want to SUM the varchar columns. This is the parameter passed that defines the two different queries.
On Tue, Aug 31, 2010 at 11:48 AM, misiaQ <mis...@poczta.fm> wrote: > I don't think that SUM will work for varchar columns. > If I got your point right - you need to use WITH ROLLUP grouping > http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html > > see second example on that page. > > regards, > m > > -----Original Message----- > From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] > Sent: Tuesday, August 31, 2010 11:43 AM > To: [MySQL] > Subject: MySQL SUM on two columns > > Hi, > > I've the following basic SUM for our products based on a rating. > > SELECT SUM(products.rating) AS products_rating > FROM products_sales > INNER JOIN products ON products_sales.products_id = products.products_id > WHERE products.enabled = 1 > AND products_sales.language = 'EN' > > This works fine, however I also want to SUM the ES language within the same > query. Is this possible to do, or should I just query the table twice, > replacing the language parameter ? > > Thanks. > > Neil > > > ---------------------------------------------------------------------- > Saloon gier - to nas wyroznia! > Sprawdz >>> http://linkint.pl/f27e0 > >
