coba pake sql berikut, mudah-mudahan membantu
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
(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
[EMAIL PROTECTED] wrote:
saya punya TABEL dibawah ini
TABEL 1
NO LOKASI GOL QTY
1. STORE A 1 20
2. STORE A 2 10
3. STORE A 3 15
untuk mendapatkan query seperti dibawah ini
bagaimana caranya yachhhhh ?
NO LOKASI GOL 1 GOL 2 GOL 3
1 STORE A 20 10 15
Mohon bantuanya
Ali Akbar
Send instant messages to your online friends http://uk.messenger.yahoo.com
__._,_.___
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
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.
