Perfect. Exactly what I was looking for.
On Tue, Aug 31, 2010 at 12:06 PM, John Daisley
> 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.language
> Will give the sum for each language.
> On 31 August 2010 11:42, Tompkins Neil <neil.tompkins@stripped>wrote:
>> 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
>> query. Is this possible to do, or should I just query the table twice,
>> replacing the language parameter ?
> John Daisley
> Certified MySQL 5 Database Administrator
> Certified MySQL 5 Developer
> Cognos BI Developer
> Telephone: +44 (0)7918 621621
> Email: john.daisley@stripped