kalo support, bisa pake yg di bawah (yg lebih optimized ketimbang yg sebelumnya)
select count(distinct(member_id)) from tb_bonus a
where exists (select * from tb_bonus b where
a.member_id=b.member_id and hadiah>0)
asumsi: hadiah gak ada yg negatif :D
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.
