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: > é�ä¿¡è : 件å��: Re: [Programmer-VB] Tanya query > lagi > [EMAIL PROTECTED] > ogroups.com > > > 07/04/2006 11:10 > AM > Programmer-VB ã�¸è¿ > ä¿¡ã�ã�¦ã��ã� ã�ã� > > > > > > > > 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/
