Arsip: helppp...query sql

more 15 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 15 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 15 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 15 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 15 years ago
batozai
saya coba pake query biasa mau.....
terima kasih banyak atas bantunaanya....
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Yang baru sejak Delphi 7
by deLogic in Tip n Trik Pemrograman more 17 years ago - error koneksi mysql dari client ke server
by bigsto in MySQL more 17 years ago - primary key
by brodien in MsSQL more 18 years ago - mengecek properti untuk semua objek sejenis
by benyy in Tip n Trik Pemrograman more 18 years ago - Tanya Client Server lg....
by nuno_irfan in MsSQL more 17 years ago - [ask] client server terhalang oleh firewall
by krizzna in Tip n Trik Pemrograman more 18 years ago - ada yang punya komponen FBus nggak ???
by doditali in Network, Files, I/O & System more 19 years ago - Struktur tanggal kok "INT" yach di mysql
by hendra74 in MySQL more 16 years ago - Mengganti Icon File Applikasi yang runtime
by DeulleDo-X in Hal umum tentang Pascal Indonesia more 19 years ago - Mohon bantuan scale tampilan display MediaPlayer
by nizar in Hal umum tentang Pascal Indonesia more 19 years ago