Arsip: Menampilkan Data Tabel Master tanpa Tabel Detail

more 10 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 10 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
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- popup messsage to client
by nurez in Tip n Trik Pemrograman more 15 years ago - ambil data paling akhir d dbgrid
by rizu in Tip n Trik Pemrograman more 14 years ago - Private server RO
by adhiet_cool7 in Games more 15 years ago - Help Zeos Query (ZQuery)
by rony_harlieanto in Hal umum tentang Pascal Indonesia more 16 years ago - menjalankan beberapa prosedur di button...
by idhiel in Tip n Trik Pemrograman more 10 years ago - Yang baru sejak Delphi 7
by deLogic in Tip n Trik Pemrograman more 15 years ago - TCP/IP Pada Delphi
by hesarewa in Network, Files, I/O & System more 11 years ago - Membernya koq dikit ya ?????
by EkoIndri in Kritik & Saran more 17 years ago - Tips Atasi gagal koneksi ketika menggunakan ADOConnection...
by EkoIndri in Tip n Trik Pemrograman more 16 years ago - Mulai firebird masih bingung ???
by aakdedy in FireBird more 13 years ago