I-BEGO

Indonesian Best Generation

Skip to content

[ASK] Tabel Kesamping

Forum diskusi membahas semua mengenai MySQL Server

Moderator: trail

Post a reply

[ASK] Tabel Kesamping

Postby vbonyon » 13 Jan 2012, 15:59

kawan2 mau bertanya, saya punya tabel sperti ini
contoh : no_reg deskripsi Total
R001 Biaya Adm 2000
R001 Jasa 3000
R001 Kartu 1000

g mana agar munculnya seperti ini
no_reg Biaya adm Jasa Kartu
R001 2000 3000 1000
mungkin ada kawan2 yg expert dan mau berbagi ilmunya.....
thanks
vbonyon
Prajurit Dua
Prajurit Dua
 
Posts: 10
Joined: 15 Mar 2010, 14:30
Memberi kopi: 0 cangkir
Mendapat kopi: 0 cangkir
Top

Re: [ASK] Tabel Kesamping

Postby novaedp » 14 Jan 2012, 10:06

kayae harus pake crosstab query tuh...
just wanna code something and share it.
novaedp
Prajurit Kepala
Prajurit Kepala
 
Posts: 468
Joined: 26 Mar 2010, 18:56
Memberi kopi: 8 cangkir
Mendapat kopi: 58 cangkir
Top

Re: [ASK] Tabel Kesamping

Postby vbonyon » 15 Jan 2012, 00:06

novaedp wrote:kayae harus pake crosstab query tuh...

boleh di share caranya master...thanks
vbonyon
Prajurit Dua
Prajurit Dua
 
Posts: 10
Joined: 15 Mar 2010, 14:30
Memberi kopi: 0 cangkir
Mendapat kopi: 0 cangkir
Top
Post a reply

Return to MySQL

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

-- SEO --