Re: [Programmer-VB] tanya query

Eko Yahoo Thu, 13 Jul 2006 00:53:21 -0700

sebelumnya makasih atas info query-nya, jadinya begini

select A.NOPER,(select sum(B.nilai) from glmutkum as B where A.noper=B.noper and B.kode='D') as NilaiD,
(select sum(C.nilai) from glmutkum as C where A.noper=C.noper and C.kode='K') as NilaiK
from glmutkum as A where left(A.noper,9) ='11.01.001' group by A.NOPER

lalu saya nambahkan lagi satu field dari tabel lain seperti ini

select A.NOPER,(select D.namper from gl as D where A.noper=D.noper) as nama ,(select sum(B.nilai) from glmutkum as B where A.noper=B.noper and B.kode='D') as NilaiD,
(select sum(C.nilai) from glmutkum as C where A.noper=C.noper and C.kode='K') as NilaiK
from glmutkum as A where left(A.noper,9) ='11.01.001' group by A.NOPER

kok ndak jalan ya

----- Original Message -----

From: Ronald Irawan

To: [email protected]

Sent: Thursday, July 13, 2006 2:05 PM

Subject: Re: [Programmer-VB] tanya query

Coba ini
select A.NOPER,(select sum(b.nilai) from tablenya B where A.noper=B.noper and B.kode='D') as NilaiD,
(select sum(C.nilai) from tablenya C where A.noper=C.noper and C.kode='K') as NilaiK
from Tablenya A group by A.NOPER

CMIIW,

Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta

"Eko Yahoo" <[EMAIL PROTECTED]>
Sent by: [email protected]
13/07/2006 01:51 PM

Please respond to
[email protected]

To
<[email protected]>

cc

Subject
[Programmer-VB] tanya query

misal saya pny tabel seperti ini

Bukti Noper nilai kode
K-1 11.01.001.0001 9000 D
K-2 11.01.001.0001 8000 K
K-3 11.01.001.0001 8500 D
K-1 11.01.001.0002 6000 D
K-2 11.01.001.0002 7000 K
K-3 11.01.001.0002 8500 D

select A.NOPER,(select sum(b.nilai) from tablenya B where A.noper=B.noper and B.kode='D') as NilaiD,
(select sum(C.nilai) from tablenya C where A.noper=C.noper and C.kode='K') as NilaiK
from Tablenya A group by A.NOPER

gimana query-nya agar menjadi
noper sum(nilai dg kode 'D') sum(nilai dg kode 'K')
11.01.001.0001 17500 8000
11.01.001.0002 14500 7000

__._,_.___

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

Kirim email ke