Makasih Pak Mario, sudah bisa dan sederhana koq
SELECT Lokasi,
SUM(IF(gol=1,jumlah,NULL)) AS gol1,
SUM(IF(gol=2,jumlah,NULL)) AS gol2,
SUM(IF(gol=3,jumlah,NULL)) AS gol3
FROM tabel1 GROUP BY lokasi;
--------------- ini aq jalankan di PHP dengan database MySQL ...
Best Regards
----- Original Message ----
From: Mario Indra Jaya <[EMAIL PROTECTED]>
To: [email protected]
Cc: [EMAIL PROTECTED]
Sent: Friday, November 30, 2007 11:01:18 AM
Subject: RE: [Programmer-VB] OOT : Crosstab Query di PHP MySQL ... pake VB bisa
...
Dear Friends,
Coba pakai query dibawah ini, biasanya ini ANSI SQL yang umum dipakai.
------------ --------- --------- --------- --------- --------- ---------
--------- --------- --------
SELECT lokasi, gol1=SUM(gol1) , gol2=SUM(gol2) , gol3=SUM(gol3)
FROM (
SELECT lokasi, gol1=sum(qty) , gol2=0, gol3=0
FROM TABEL1
WHERE gol='1'
GROUP BY lokasi
UNION ALL
SELECT lokasi, gol1=0, gol2=sum(qty) , gol3=0
FROM TABEL1
WHERE gol='2'
GROUP BY lokasi
UNION ALL
SELECT lokasi, gol1=0, gol2=0, gol3=sum(qty)
FROM TABEL1
WHERE gol='3'
GROUP BY lokasi
) A
GROUP BY lokasi
Best Regards,
From: Programmer-VB@ yahoogroups. com [mailto: Programmer-VB@ yahoogroups. com
] On Behalf Of Sumardi Mardi
Sent: Friday, November 30, 2007 8:41 AM
To: Programmer-VB@ yahoogroups. com
Subject: [Programmer- VB] OOT : Crosstab Query di PHP MySQL ... pake VB bisa ...
sohib,
ada yang bisa bantu ?
saya punya TABEL dibawah ini
TABEL 1
NO LOKASI GOL QTY
1. JAYAPURA 1 20
2. JAYAPURA 2 10
3. JAYAPURA 3 15
Query untuk mendapatkan hasil seperti berikut, gimana caranya ya ??
NO LOKASI GOL 1 GOL 2 GOL 3
1 JAYAPURA 20 10 15
aq coba pake query berikut :
select lokasi,sum(g1) as gol1 ,sum(g2) as gol2,sum(g3) as gol3 from
(SELECT lokasi, IIf(gol='1', sum(qty), 0) AS g1,IIf(gol=' 2',sum(qty) ,0) AS
g2,IIf(gol=' 3',sum(qty) ,0) AS g3
FROM table1 group by lokasi,gol) group by lokasi
bisa, tapi untuk VB / Access
aku coba di PHP dengan db MySQL error ... trus perintah IIF -nya aku pecah pake
IF biasa juga masih belum bisa
plis .... thx b4
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
