coba kaya gini
select A.NOPER,(select D.namper from gl D where A.noper=D.noper) as
nama ,(select sum(B.nilai) from glmutkum B where A.noper=B.noper and
B.kode='D') as NilaiD, (select sum(C.nilai) from glmutkum C where
A.noper=C.noper and C.kode='K') as NilaiK
from glmutkum A where
left(A.noper,9) ='11.01.001' group by A.NOPER
Kalau msh blm bisa, tabel GL nya kaya gimana yah?
Salam
Ronald Irawan
Pt. Sanghiang
Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
tidak ada data tapi
menurutku harusnya ada ----- Original Message ----- From:
Ronald
Irawan To:
[email protected]
Sent: Thursday, July 13, 2006 3:02 PM
Subject: Re: [Programmer-VB] tanya query
gak jalan nya error? atau gak ada
datanya?
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha
Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
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
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
