Arsip: helppp...query sql

more 11 years ago
batozai
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

more 11 years ago
bagussb
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

more 11 years ago
batozai
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, KETterima 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....

more 11 years ago
alhass
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.

more 11 years ago
batozai
saya coba pake query biasa mau.....
terima kasih banyak atas bantunaanya....
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- Gimana ambil data dari Excel yang tidak konsisten?
by hendra_sir84 in Hal umum tentang Pascal Indonesia more 13 years ago - Mask / DisplayFormat pada QuickReport
by bad2001 in Reporting more 12 years ago - menjalankan dos command
by dinox in Tip n Trik Pemrograman more 15 years ago - Hide program dari Taskmanager
by DeTerMaL in Tip n Trik Pemrograman more 13 years ago - ttg tanggal.....???
by Rogeb_Shewrite in Tip n Trik Pemrograman more 14 years ago - Pencocokkan String ( String Matching) Delphi DanMySQL ??
by daryl_sukma_gumilar in MySQL more 11 years ago - CARA MENGETAHUI SISA RANGE TANGGAL
by hak3nd3n in Tip n Trik Pemrograman more 12 years ago - [?] Menghapus Record Master Detail di Paradox
by babypigs in Paradox more 12 years ago - Fast Report dan MySql ?
by armanefendi in MySQL more 13 years ago - Search File Yang Memiliki Format
by xproof in Tip n Trik Pemrograman more 11 years ago