--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:

> quinton_marks wrote:
> > I want to use Count(*) in my Select Statement with other fields
> > eg. Select Field1, Count(*) FROM TABLE 1
>
> select field1, count(*) from table1 group by field1
>
> > but I keep getting a Dynamic SQL Error : Invalid column reference

on

> > line 1.....
> >
> > If I take the Count(*) out it works fine. This also applies to

all

> > Aggregate functions SUM, AVE etc.
> >
> > Anybody got an Idea?
>
> You should take some time and learn SQL. You will benefit from it

later.

Seeing as though you know so much, how about telling me how to do it?

>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net