Pake group by aja. Select no_faktur, sum( opening ) as opening, sum( in ) as in, sum( out ) as out From table Group by no_faktur
-----Original Message----- From: Juned Syafruddin <[EMAIL PROTECTED]> Date: Sun, 13 Apr 2008 22:57:45 To:[email protected], [EMAIL PROTECTED] Subject: [Programmer-VB] Tanya QUery Dear Programmer mohon bantuannya Saya punya Tabel seperti ini NO FAKTUR , OPENING, IN, OUT AA 100 0 0 AA 0 50 0 AA 0 0 30 Bagaimana Menghasilkan Tampilan Seperti ini NO FAKTUR , OPENING, IN, OUT AA 100 50 30 Terima kasih ------------------------------------ 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: wahana.programmer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Programmer-VB/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
