[TANYA] Grid by noo_r1r1n @ delphi-id.org

Permisi suhu-suhu dan master-master, minta bantuannya..

misalkan di tabel tarif

Id Nama JenisPerika Tarif
45 B Admin 10000
01 B Konsultasi 20000
02 B A1 5000
. B . .
. B . . , dst sampai
44 B A43 7500

yg jadi pertanyaan, bagaimana menampilkan di grid supaya tampilannya seperti berikut :

Nama Admin Tindakan Konsultasi
B 10000 xxxx 20000

Field Tindakan merupakan sum JenisPeriksa dari Id selain 01 dan 45

Mohon pencerahannya...

try this,

select
Nama, Admin, Tindakan, Konsultasi
from
(select Nama, sum(Tarif) as Admin from tarif where Id='45' group by Nama) as adm,
(select Nama, sum(Tarif) as Tindakan from tarif where Id<>'45' and Id<>'01' group by Nama) as tind,
(select Nama, sum(Tarif) as Konsultasi from tarif where Id='01' group by Nama) as kons
where
adm.Nama = 'B' and
tind.Nama = 'B' and
kons.Nama = 'B'


link http://delphi-id.org