Re: [Programmer-VB] tanya query

[Kyan Mada Pramana]

 SELECT *,sum(if(kode='D', nilai, 0)) AS D ,sum(if(kode='K', nilai, 0)) as K FROM database GROUP BY noper OL ----- Original Message ----- From: Eko Yahoo To: Programmer-VB@yahoogroups.com Sent: Thursday, July 13, 2006 1:51 PM Subject: [Programmer-VB] tanya query misal saya pny tabel seperti ini   Bukti         Noper                      nilai                 kode K-1            11.01.001.0001        9000                  D K-2            11.01.001.0001        8000                  K K-3            11.01.001.0001        8500                  D K-1            11.01.001.0002        6000                  D K-2            11.01.001.0002        7000                  K K-3            11.01.001.0002        8500                  D   gimana query-nya agar menjadi noper                  sum(nilai dg kode 'D')                  sum(nilai dg kode 'K') 11.01.001.0001              17500                                      8000 11.01.001.0002              14500                                      7000 __._,_.___ 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  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. __,_._,___