[Programmer-VB] tanya query

[Eko Yahoo]

 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 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. __,_._,___