Subject | Firebird 1.0.3 select group by -> invalid column reference |
---|---|
Author | tsangccn |
Post date | 2003-08-29T04:39:20Z |
Hello,
I am using Firebird 1.0.3. But when I issue the following SQL
statement, I always get a invalid column reference error.
SELECT * FROM MEMBERSHIP GROUP BY USERNAME;
But the following run OK
SELECT * FROM MEMBERSHIP ORDER BY USERNAME;
I seems Firebird does not support the GROUP BY. Is it?
Thanks
C. N.
I am using Firebird 1.0.3. But when I issue the following SQL
statement, I always get a invalid column reference error.
SELECT * FROM MEMBERSHIP GROUP BY USERNAME;
But the following run OK
SELECT * FROM MEMBERSHIP ORDER BY USERNAME;
I seems Firebird does not support the GROUP BY. Is it?
Thanks
C. N.