Thank's Mas Pian. Aku kira sudah ngga aktif lagi di Milis VB. Hehehe. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of vbPian Sent: 03 Agustus 2009 12:52 To: [email protected] Subject: Re: [Programmer-VB] Tanya: Query kolom jadi baris.
SELECT 'SPP' AS Jenis, Bulan, Tahun, SPP AS Jumlah FROM tblTabel UNION SELECT 'UM' AS Jenis, Bulan, Tahun, UM AS Jumlah FROM tblTabel UNION SELECT 'DK' AS Jenis, Bulan, Tahun, DK AS Jumlah FROM tblTabel UNION SELECT 'DPS' AS Jenis, Bulan, Tahun, DPS AS Jumlah FROM tblTabel UNION SELECT 'LAIN' AS Jenis, Bulan, Tahun, LAIN AS Jumlah FROM tblTabel Regards, On 31/07/2009, Frangky <[email protected]> wrote: > Mohon teman-teman meluangkan waktu untuk masalah saya dibawah ini. > > Saya mempunyai table seperti ini: > > > > SPP UM DK DPS LAIN BULAN TAHUN > > 100 0 75 25 425 JULI > 2009 > > 100 0 75 25 425 AUG > 2009 > > > > Bagaimana lakukan query seperti ini: > > > > JENIS BULAN TAHUN > JUMLAH > > SPP JULI 2009 > 100 > > UM JULI 2009 > 0 > > DK JULI 2009 > 75 > > DPS JULI 2009 > 25 > > LAIN JULI 2009 > 425 > > SPP AUG 2009 > 100 > > UM AUG 2009 > 0 > > DK AUG 2009 > 75 > > DPS AUG 2009 > 25 > > LAIN AUG 2009 > 425 > > > > Terima kasih sebelumnya. > > > > -- Best Regard ------------------------------------ Wahana Programmer Groups Links Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.33/2267 - Release Date: 07/27/09 17:59:00
