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
|
|
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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Everything you need is one click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/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.
