Subject | Select with Group By error |
---|---|
Author | Hardy , |
Post date | 2010-08-09T12:25:24Z |
I have table with following colum
Table A
* column-1
* column-2
column-3
column-4
my Select clause as follow:
Select column2, sum(column-3) Tot-1, sum(column-4) Tot-2
group by column2
I use TIBOQuery version 4.8.7 to generate the Group by Select
When I run the program it is looking for Column-1
with message Column-1 is not found
If I run this SQL in IBExpert, it is work well ?
Did I missing something .....? Please help
[Non-text portions of this message have been removed]
Table A
* column-1
* column-2
column-3
column-4
my Select clause as follow:
Select column2, sum(column-3) Tot-1, sum(column-4) Tot-2
group by column2
I use TIBOQuery version 4.8.7 to generate the Group by Select
When I run the program it is looking for Column-1
with message Column-1 is not found
If I run this SQL in IBExpert, it is work well ?
Did I missing something .....? Please help
[Non-text portions of this message have been removed]