Coba subquery berikut : select a1.aname,b1.amount as bamount,a1.amount as aamount from (select a.aname,sum(a.aamount) as amount from actual$ as a group by a.aname) as a1 inner join (select b.bname,sum(b.bamount) as amount from budget$ as b group by b.bname) as b1 on a1.aname=b1.bname
Tabel actual ada di sheet actual Tabel budget ada di sheet budget Kid. On Sun, Mar 25, 2012 at 18:18, <[email protected]> wrote: > ** > > > Dear XL-Mania, > > Saya memiliki 2 table seperti contoh terlampir. Saya ingin menggabungkan 2 > table tersebut menjadi 1 table dengan menggunakan xlsql yg ada di excel. > Saya sudah coba tapi hasilnya selalu menjadi doble. Mohon pencerahannya > agar table hasil gabungannya menjadi: > > Name. BAmount. AAmount > A. 1. 4 > B. 1. 2 > > Regards, > Syawal > > > Powered by Telkomsel BlackBerry® > > -----Original Message----- > From: Syawaludin Syarief <[email protected]> > Date: Sun, 25 Mar 2012 18:06:27 > To: Syawaludin Syarief<[email protected]> > Subject: Joint 2 table > > > > >
