On Friday 16 July 2004 07:32, uwekeim wrote:

Hi,

> --->
>
> SELECT SOMETHING, colA*colB as PRICE
> FROM PRICES
> GROUP BY SOMETHING, colA*colB as PRICE
>
> <---
>
> does not work.

Try

SELECT SOMETHING, colA*colB as PRICE
FROM PRICES
GROUP BY SOMETHING, 2

Phil

--
Discover a lost art - play Marbles
May 2004
www.marillion.com
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | pjshrimpton@...