Re: [Programmer-VB] Tanya query lagi (koreksi)

[thakin Caca]

maaf Querynya kepotong, aslinya kayak gini 

 

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

coba pake query berikut

 

SELECT lokasi ,gol1,gol2,gol3  FROM
(SELECT lokasi , IIf(gol='1',sum(qty),0)AS gol1, IIF(gol='2',sum(qty),0)AS gol2, IIF(gol='3',sum(qty),0) AS gol3
FROM Table1 group by lokasi ,gol) a

[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

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.

---

__,_._,___