| Author |
Message |
batozai |
| Location: |
|
Post subject: helppp...query sql
 Posted: 25/Sep/2009 15:36
|
|
onIntermediate
Joined: 08-May-2006
Posts: 52
Status: Offline
|
|
para master tanya lagi gimana caranya query utk hasil spt berikut :
aku punya tabel Tmarketing dan Tmarketing_detail
Tmarketing punya ID sbg primary key, id itu digunakan sbg foreign key di Tmarketing_detail.
Tmarketing detail punya field NOMINAL. relasinya dari Tmarketing ke Tmarketing_Detail 1----N
Data di Tmarketing
ID Ket
------------------------------
1 Promosi Ke Jakarta
2 Buat Baliho
3 Study Banding Ke Malaysia
Data di Tmarketing_Detail
Marketing_ID Nominal
----------------------------------
1 200.000
1 300.000
2 200.000
2 300.000
2 100.000
3 400.000
4 300.000
uku ingin mengquery hasil spt ini :
ID Ket Total Nominal
----------------------------------------------------------------------
1 Promosi Ke Jakarta 500.000
2 Buat Baliho 600.000
3 Study Banding Ke Malaysia 700.000
aku dah coba2 beberapa query tapi hasilnya ga mau. malah error terus.
kadang semua baris di Tmarketing detail muncul...
pls help me,
------------------------------------------------------------------------------------
semoga amal dan kebaikan para master mendapat balasan setimpal dari-NYA |
|
|
| |
|
|
|
 |
|
bagussb |
| Location: Bandung |
|
|
Post subject: RE: helppp...query sql
Posted: 25/Sep/2009 16:48
|
|
onSkilled
Joined: 02-Aug-2007
Posts: 113
Location: Bandung
Status: Offline
|
|
SELECT ID, KET, SUM(ISNULL(Nominal,0)) AS NOMINAL
FROM TMarketing T0 LEFT OUTER JOIN TMarketing_Detail T1 ON T0.ID = T1.Marketing_ID
GROUP BY ID, KET |
_________________
spider boy on action ...
|
| |
|
|
|
|
|
batozai |
| Location: |
|
|
Post subject: RE: helppp...query sql
Posted: 25/Sep/2009 18:13
|
|
onIntermediate
Joined: 08-May-2006
Posts: 52
Status: Offline
|
|
|
Quote:
SELECT ID, KET, SUM(ISNULL(Nominal,0)) AS NOMINAL
FROM TMarketing T0 LEFT OUTER JOIN TMarketing_Detail T1 ON T0.ID = T1.Marketing_ID
GROUP BY ID, KET
terima kasih atas balasannya. saya sudah coba kode diatas. tapi error
error menunjuk ke ISNULL. trus saya del ISSNUL error menunjuk ke ,0 trus saya del akhirnya jadi seperti ini
SELECT ID, KET, SUM(Nominal) AS NOMINAL
FROM TMarketing T0 LEFT OUTER JOIN TMarketing_Detail T1 ON T0.ID = T1.Marketing_ID
GROUP BY ID, KET
dan bisa dieksekusi. saya menggunakan Interbase 7.1
kenapa ya perintah itu tidak dikenal di interbase ?
terimaksih banyak mas bagussb atas bantuannya.... |
|
|
| |
|
|
|
|
|
alhass |
| Location: |
|
|
Post subject: RE: helppp...query sql
Posted: 25/Sep/2009 19:46
|
|
onIntermediate
Joined: 13-May-2009
Posts: 34
Status: Offline
|
|
Coba pake query yg biasa sj.
SELECT ID, Ket, SUM(Nominal) AS TOTAL_NOMINAL
FROM TMarketing,TMarketing_Detail
WHERE TMarketing_Detail.Marketing_ID=TMarketing.ID
GROUP BY ID, Ket
dgn query spt ini mungkin akan mudah dipahami. couse masing2 DB memiliki karakteristik berbeda. |
|
|
| |
|
|
|
|
|
batozai |
| Location: |
|
|
Post subject: RE: helppp...query sql
Posted: 26/Sep/2009 07:11
|
|
onIntermediate
Joined: 08-May-2006
Posts: 52
Status: Offline
|
|
saya coba pake query biasa mau.....
terima kasih banyak atas bantunaanya.... |
|
|
| |
|
|
|
|
|
|
