Arsip: Menampilkan Data Tabel Master tanpa Tabel Detail

 
user image
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
user image
more 8 years ago

denmasdanang

pakai query mas
user image
more 8 years ago

IdrisZZ

Maaf Mas, bisa diberikan contoh query nya gak ? Terimakasih
user image
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 Terimakasih
contoh 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
thx
more ...
  • Pages:
  • 1
Share to

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com