Re: [Programmer-VB] Tanya query lagi

dayat Wed, 05 Jul 2006 21:39:04 -0700

Ikutan ya, mudah2an benar. Coba pake query dibawah ini:

SELECT query1.Location, COUNT(query1.typeA)AS typeA, COUNT(query1.typeB)AS typeB, COUNT(query1.typeC)
FROM (SELECT Location, IIF(type='A', 1, NULL)AS typeA, IIF(type='B', 1, NULL) AS typeB, IIF(type='C', 1, NULL)AS typeC FROM table1)query1 GROUP BY query1.Location;

klo sukses atau gagal bilang ya.

On 7/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

OK

pake data yg lain deh...tapi problemnya sama

No.  Location   Type
1       Store           A
2       Store           C
3       Store           B
4       Store           A
5       Store           C
6       Store           C

menjadi satu baris

No   Location    typeA    typeB  typeC
1       Store               2         1           3

                      thakin Caca
                      <[EMAIL PROTECTED]         To:      [email protected]
                      o.com>                     cc:
                      Sent by:                   Subject: Re: [Programmer-VB] Tanya query lagi
                      [EMAIL PROTECTED]
                      ogroups.com

                      07/05/2006 12:49
                      PM
                      Please respond to
                      Programmer-VB

bisa diperjelas pertanyaanya mas [IMAGE]

[EMAIL PROTECTED] wrote:

ma kasih atas pencerahanya

mas caca ada satu lagi neh klo tabelnyya 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

__._,_.___

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

SPONSORED LINKS

`Programmer`	`Indonesia`	`Basic programming language`
`Computer programming languages`	`Programming languages`	`Java programming language`

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.

__,_._,___

Re: [Programmer-VB] Tanya query lagi

Kirim email ke