Waduh, makasih Pak....saya jajal dahulu Elang --- On Fri, 7/9/10, Aksan Kurdin <[email protected]> wrote:
From: Aksan Kurdin <[email protected]> Subject: Re: [belajar-access] Left Join To: [email protected] Date: Friday, July 9, 2010, 3:33 PM gunakan summary dari union sub query seperti: select X.kelurahan, sum(X.jlh_NPWP) as jlhNPWP, sum(X.jlh_SIUP) as jlhSIUP, sum(X.jlh_TDP) as jlhTDP FROM ( select kelurahan, jlh_npwp, 0 as jlh_SIUP, 0 as jlh_TDP FROM TabelA UNION ALL select kelurahan, 0 as jlh_npwp, jlh_SIUP, 0 as jlh_TDP FROM TabelB UNION ALL select kelurahan, 0 as jlh_npwp, 0 as jlh_SIUP, jlh_TDP FROM TabelC ) AS X GROUP BY KELURAHAN aksan kurdin On 7/9/2010 4:03 PM, N17R4 H4F45 wrote: mas elang, bukannya kalo sampean pake query designer msacc lebih enak dan kalau hasil kurang sesuai, ngubahnya gampang From: CGSATU <cgs...@yahoo. com> To: belajar-access@ yahoogroups. com Sent: Friday, July 9, 2010 15:09:35 Subject: [belajar-access] Left Join Mungkin atau tidak ya...LEFT JOIN lebih dari dua tabel? Skenario sbb : Saya punya 3 tabel (sudah tidak bisa diutik) sbb : TabelA : Kelurahan | Jlh_NPWP ------------ --------- --------- - Blooto | 2 Magersari | 3 Meri | 0 TabelB : Kelurahan | Jlh_SIUP ------------ --------- --------- - Miji | 0 Magersari | 1 Meri | 2 TabelC : Kelurahan | Jlh_TDP ------------ --------- --------- - Blooto | 1 Sentanan | 1 Wates | 1 Keinginan saya, tiga tabel tersebut bisa digabungkan : Tabel_Laporan Kelurahan | Jlh_NPWP | Jlh_TDP | Jlh_SIUP ------------ --------- --------- --------- --------- --------- - Blooto |2 |1 |0 Magersari | 3 |0 atau N/A |1 Meri |0 |0 atau N/A |2 Miji |0 atau N/A |0 atau N/A |2 Kalau iseng saya buat : SELECT TabelA.Jlh_NPWP, TabelB.Jlh_SIUP, TabelB.kelurahan, TabelA.kelurahan FROM TabelA LEFT JOIN TabelB TabelA.kelurahan = TabelB.kelurahan; Hasilnya sih, meski "agak menceng" masih bisa "diterima". Nah, kalau TabelC mau diikutikan juga, bagaimana ya caranya ? Soalnya LEFT JOIN atau RIGHT JOIN kan aslinya cuma 2 tabel...... :( Elang
