Arsip: Menampilkan Data Tabel Master tanpa Tabel Detail

more 8 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 8 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
- 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
- program rambah schedule task...help...
by adhisyanda in Paradox more 11 years ago - Kartu magnetik
by julius in Hal umum tentang Pascal Indonesia more 13 years ago - Showmessage di tengah2 form
by r_rie in Tip n Trik Pemrograman more 11 years ago - multi camera dengan DSPack
by agil in Multimedia & Graphic Enhancement more 8 years ago - hal:cara nentuin icon aplikasi?
by Zulkarnain in Multimedia & Graphic Enhancement more 13 years ago - Printer mini epson TM U220B
by wati in Tip n Trik Pemrograman more 9 years ago - could not compile use unit 'ActiveX.pas'?
by johnizzy in Tip n Trik Pemrograman more 12 years ago - komponen delphi 7
by idhiel in Form Enhancement & Graphical Controls more 9 years ago - Tolong donk.....Masalah image neh..
by willbrig in Tip n Trik Pemrograman more 13 years ago - Kebiasaan para programmer
by budicysco in OOT more 13 years ago