sayang firebird tidak support select from select.
Ada nggak sintak alternative?
-----Original Message-----
From: panji aryaputra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: [Delphindo] SQL untuk menghitung record dari select-group
eh kurang tepat ya. ya udah gini aja
select count(*) from
(SELECT MEMBER_ID, SUM(HADIAH) as TOTAL_HADIAH
FROM TB_BONUS
GROUP BY MEMBER_ID
HAVING SUM(HADIAH) > 0)
hehehehe.
mudah2an ga salah lagi.
hth
panji.a
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
