select a.name,a.kota,(select count(id) from bon where a.id=id_cust) JmlBon,
(select Nominal from Giro where a.id=id_cust)> TotalBon,
(select count(id) from Giro where a.id=id_cust) JmlGiro,
(select sum(nominal) from giro where a.id=id_cust) totalgiro
from customer a
Mudah2xan bisa
CMIIW
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| budiman Lai <[EMAIL PROTECTED]>
Sent by: [email protected] 22/05/2006 12:03 PM
|
|
Sebelumnya terima kasih buat reply-nya. Untuk yang
Giro, mungkin contoh data yang saya kasih kurang
lengkap. Untuk contohnya:
Tabel: Bon
ID ID_Cust Nominal ID_Giro
1 1 10000 1
2 1 20000 1
3 2 30000 2
4 4 40000 3
5 1 50000 4
Tabel: Giro
ID Nominal ID_Cust
1 30000 1
2 30000 2
3 40000 4
4 50000 1
Hasil resultnya:
Nama Kota JmlhBon TotalBon JmlhGiro TotalGiro
Agus Jakarta 3 80000 2 80000
Budi Jakarta 1 30000 1 30000
Chandra Jakarta 0 0 0 0
Deni Jakarta 1 40000 1 4
Thanks banyak
Salam
Budi
--- Ronald Irawan <[EMAIL PROTECTED]> wrote:
> Ini yg terpikirkan pertama kali, mudah2an ada yg
> merevisis spy lebih
> ringkas
> select a.name,a.kota,(select count(id) from bon
> where a.id=id_cust)
> JmlBon,
> (select Nominal from Giro where a.id=id_cust)
> TotalBon,
> (select count(id) from Giro where a.id=id_cust)
> JmlGiro,
> --Nah Total giro yg saya bingung ngambil dari mana,
> plg tdk anda tahu
> maksud saya yah..
> from customer a
>
>
> Salam
> Ronald Irawan
> Pt. Sanghiang Perkasa
> Gd. Graha Kirana Lt.5
> Jl Yos Sudarso Kav.88
> Jakarta
>
>
>
> budiman Lai <[EMAIL PROTECTED]>
> Sent by: [email protected]
> 21/05/2006 11:00 PM
> Please respond to
> [email protected]
>
>
> To
> Programmer-VB <[email protected]>,
> Indonesia PHP
> <[EMAIL PROTECTED]>
> cc
>
> Subject
> [Programmer-VB] SQL - Mohon bantuannya.
>
>
>
>
>
>
> Tabel: customer
> ID name kota
> 1 Agus Jakarta
> 2 Budi Jakarta
> 3 Chandra Jakarta
> 4 Deni Jakarta
>
> Tabel: Bon
> ID ID_Cust Nominal ID_Giro
> 1 1 10000 1
> 2 1 20000 1
> 3 2 30000 2
> 4 4 40000 3
>
> Tabel: Giro
> ID Nominal ID_Cust
> 1 30000 1
> 2 30000 2
> 3 40000 4
>
> Hasil yang akan di tampilkan adalah
> Nama Kota JmlhBon TotalBon JmlhGiro
> TotalGiro
> Agus Jakarta 2 30000 1 30000
> Budi Jakarta 1 30000 1 30000
> Chandra Jakarta 0 0 0 0
> Deni Jakarta 1 40000 1 4
>
>
> Mohon bantuan SQL Query-nya dari senior2 di milis
> ini.
> Saya dah coba tapi cuma bisa tampilkan nama, kota,
> dan
> totalbon.
>
> Sebelum dan sesudahnya saya ucapkan banyak terima
> kasih.
> Budi
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
>
>
> Wahana Programmer Groups Links
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
=======================================
Please visit my Yahoo!360
http://360.yahoo.com/budiman_lai
Rp. 100.000 + 2 orang = puluhan juta rupiah + free pulsa.
Untuk info selanjutnya click disini atau silahkan kirim email ke saya di [EMAIL PROTECTED]
=======================================
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Home is just a click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
