kasih sudah saya coba dan berhasil.
--- Ronald Irawan <[EMAIL PROTECTED]> wrote:
> 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
> Please respond to
> [email protected]
>
>
> To
> [email protected]
> cc
>
> Subject
> Re: [Programmer-VB] SQL - Mohon bantuannya.
>
>
>
>
>
>
> 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]
> =======================================
>
>
>
>
>
=== message truncated ===
=======================================
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
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.
