Subject | Using COUNT(*) |
---|---|
Author | quinton_marks |
Post date | 2004-01-19T18:01:23Z |
Hello,
I want to use Count(*) in my Select Statement with other fields
eg. Select Field1, Count(*) FROM TABLE 1
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?
Thank You in Advance
Q.
I want to use Count(*) in my Select Statement with other fields
eg. Select Field1, Count(*) FROM TABLE 1
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?
Thank You in Advance
Q.