Arsip: Menampilkan Data Tabel Master tanpa Tabel Detail

more 13 years ago
IdrisZZ
Mas, Gimana ya caranya menampilkan ke laporan Data Master-Detail. tetapi jika data di tabel Master gak ada Detail nya tetap tampil di laporannya. Contoh :
1. Master A
- Detal A.1
- Detal A.2
2. Master B
3. Master C
- Detal C.1
Terimakasih

more 13 years ago
denmasdanang
@IdrisZZ: Mas, Gimana ya caranya menampilkan ke laporan Data Master-Detail. tetapi jika data di tabel Master gak ada Detail nya tetap tampil di laporannya. Contoh : 1. Master A - Detal A.1 - Detal A.2 2. Master B 3. Master C - Detal C.1 Terimakasihcontoh tablenya bisa ga diperjelas? misalnya data dari table master diatas tidak ada relationnya contohnya seperti ini :
select masterA.field1 as A, detailA1.field1 as B, detailA2.field1 as C from masterA inner join detailA1 on masterA.field1 = detailA1.field1 inner join detailA2 on masterA.field1 = detailA2.field1
union all
select masterB.field1, '-' as B, '-' as C from masterB
union all
select masterC.field1, detailC1.field1, '-' as C from masterC inner join detailC1 on masterC.field1 = detailC1.field1
thxmore ...
- 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
- OMR
by rykemit in Enginering more 18 years ago - Surga dunia neraka akhirat
by DelphiExpert in OOT more 15 years ago - re active control
by nurez in Hal umum tentang Pascal Indonesia more 19 years ago - ginana koneksi ke DB pake file INI?
by putukaca in Tip n Trik Pemrograman more 18 years ago - validasi di dbgrid
by peak08 in Tip n Trik Pemrograman more 14 years ago - shutdown windows?
by sulth4n in Tip n Trik Pemrograman more 19 years ago - Membuat RNG ( random generator)
by astika in Tip n Trik Pemrograman more 16 years ago - [ask]menampilkan table kategori kedalam treeview??
by gedoyman in MsSQL more 17 years ago - Cari Kumpulan Glyph?
by archvile in Multimedia & Graphic Enhancement more 16 years ago - Edit, combo Box dan Array
by priki in Tip n Trik Pemrograman more 18 years ago