Select A.Field1, B.cnt
FROM
TABLE1 A,
(select count(*) CNT FROM TABLE2 ) B

if subselect not supported: use a view




-----Original Message-----
From: quinton_marks [mailto:quinton_marks@...]
Sent: 19. janúar 2004 18:01
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Using COUNT(*)


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.



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=12c58ci6i/M=267637.4116732.5333197.1261774/D=egroupw
eb/S=1705115386:HM/EXP=1074621795/A=1945637/R=0/*http://www.netflix.com/Defau
lt?mqso=60178397&partid=4116732>

<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail
/S=:HM/A=1945637/rand=381581179>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]