SELECT products_sales.language, 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 IN ('EN','ES')
GROUP BY products_sales.languageWill give the sum for each language. On 31 August 2010 11:42, Tompkins Neil <neil.tompk...@googlemail.com> wrote: > 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 > -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk
