Posted by NC on 09/11/06 15:09

Mikro wrote:
>
> What wrong on this clause?
>
> SELECT * from summad SUM(sum1+sum2+sum3)
> AS summa HAVING summa > sumall

Everything. You list a data item to select (summa) after a FROM clause
(it should be before). You also combine retrieving records with
retrieving aggregates from the same table, which doesn't make sense.

Cheers,
NC

[Back to original message]