Re: [GENERAL] Correlated Subquery and calculated column non-functional

2009-10-30 Thread Thomas Kellerer
The Frog wrote on 30.10.2009 11:07: select product.manufacturer, product.brand, SUM(sales.qtysold * sales.unitprice) as turnover, (select count(*) from cube_sales.sales as Q WHERE SUM(sales.qtysold * sales.unitprice) > turnover) + 1 as rank from cube_sales.

Re: [GENERAL] Correlated Subquery and calculated column non-functional

2009-10-30 Thread Richard Broersma
On Fri, Oct 30, 2009 at 10:42 AM, Raymond O'Donnell wrote: > On 30/10/2009 10:07, The Frog wrote: >> select >>       product.manufacturer, >>       product.brand, >>       SUM(sales.qtysold * sales.unitprice) as turnover, >>       (select count(*) from cube_sales.sales as Q WHERE SUM(sales.qtysold

Re: [GENERAL] Correlated Subquery and calculated column non-functional

2009-10-30 Thread Raymond O'Donnell
On 30/10/2009 10:07, The Frog wrote: > select > product.manufacturer, > product.brand, > SUM(sales.qtysold * sales.unitprice) as turnover, > (select count(*) from cube_sales.sales as Q WHERE SUM(sales.qtysold * > sales.unitprice) > turnover) + 1 as rank You can't use the al