mas CaCa koq ga ngerespond maya lg sih?
tolongin donk ;>

maya

--- thakin Caca <[EMAIL PROTECTED]> wrote:

> bisa diperjelas pertanyaanya mas 
> 
> [EMAIL PROTECTED] wrote:          
> ma kasih atas pencerahanya 
> 
> mas caca ada satu lagi neh klo tabelnya sperti di
> bawah ini gimana 
> 
> No Location mark 
> 1 Store **** 
> 2 Store 
> 3 Store 0000 
> 4 Store 0000 
> 5 Store **** 
> 6 Store **** 
> 
> 
> menjadi 
> 
> 
> No Location FlagBlank FlagStar FlagZero 
> 1 Store 1 
> 3 2 
> 
> bagaimana querynya 
> 
> best Regards 
> 
> Ali Akbar 
> 
> 
> 
> 
> 
> thakin Caca 
> <[EMAIL PROTECTED] 宛先:
> [email protected] 
> o.com> cc: 
> é€&#65533;信者: ä»¶å&#65533;&#65533;: Re:
[Programmer-VB] Tanya query
> lagi 
> [EMAIL PROTECTED] 
> ogroups.com 
> 
> 
> 07/04/2006 11:10 
> AM 
> Programmer-VB ã&#65533;¸è¿” 
> ä¿¡ã&#65533;—ã&#65533;¦ã&#65533;&#65533;ã&#65533;
ã&#65533;•ã&#65533;„ 
> 
> 
> 
> 
> 
> 
> 
> 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 
>  Send instant messages to your online friends
> http://uk.messenger.yahoo.com 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam
protection around 
http://mail.yahoo.com 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Great things are happening at Yahoo! Groups.  See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~-> 

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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke