Subject | Rroblem with 'group by' |
---|---|
Author | uwekeim |
Post date | 2004-07-16T07:32:38Z |
Hello,
we're switching from Paradox to Firebird. Unfortunately we must use
dialect 1.
Now we have this problem:
--->
SELECT SOMETHING, colA*colB as PRICE
FROM PRICES
GROUP BY SOMETHING, colA*colB as PRICE
<---
does not work. I've tried several variations, but didn't find a
solution.
Is there any way to solve this problem?
kind regards
Uwe Keim
we're switching from Paradox to Firebird. Unfortunately we must use
dialect 1.
Now we have this problem:
--->
SELECT SOMETHING, colA*colB as PRICE
FROM PRICES
GROUP BY SOMETHING, colA*colB as PRICE
<---
does not work. I've tried several variations, but didn't find a
solution.
Is there any way to solve this problem?
kind regards
Uwe Keim