Re: [Programmer-VB] Tanya query lagi

Thu, 06 Jul 2006 18:47:46 -0700 

coba pelajari "case ...when ..."

Maya Agnelia wrote:

> mas CaCa koq ga ngerespond maya lg sih?
> tolongin donk ;>
>
> maya
>
> --- thakin Caca <[EMAIL PROTECTED] 
> <mailto:sudden_poniq%40yahoo.com>> wrote:
>
> > bisa diperjelas pertanyaanya mas
> >
> > [EMAIL PROTECTED] <mailto:akbar-kmi%40khi.co.jp> 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] <mailto:Programmer-VB%40yahoogroups.com>
> > 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] <mailto:akbar-kmi%40khi.co.jp> 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 <http://uk.messenger.yahoo.com>
> >
> >
> >
> >
> >
> >
> >
> > Send instant messages to your online friends
> > http://uk.messenger.yahoo.com <http://uk.messenger.yahoo.com>
> > Send instant messages to your online friends
> > http://uk.messenger.yahoo.com <http://uk.messenger.yahoo.com>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com <http://mail.yahoo.com>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com <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