Aly, semoga ini bisa membantu,
select a.data_uid, (amt_tbl1-amt_tbl3) balance from (select data_uid, sum(a.amount) amt_tbl1 from table_1 group by data_uid) a inner join (select data_uid, sum(amount) amt_tbl2 from table_2 group by data_uid) b on a.data_uid = b.data_uid salam asupna www.asupna.com --- In [email protected], aly rmb <[EMAIL PROTECTED]> wrote: > > Salam semuanya, > TABLE_1 > DATA_UID AMOUNT > --------------- ------------ > 1 4 > 1 3 > 2 20 > > TABLE_2 > DATA_UID AMOUNT > --------------- ------------- > 1 7 > 2 24 > Klo queri spt ini, > select data_uid, sum(amount) > from table_1 a > group by data_uid > having sum(amount) <> (select sum(amount) > from table_2 b > where b.data_uid = a.data_uid ) > > hasilnya : > > DATA_UID AMOUNT > --------------- ------------- > 2 20 > klo Amount yg di inginkan adalah selisih antara TABLE_1 dan TABLE_2, > kira* querinya spt apa ya ? (amountnya = 4 bukan 20) > > slm/Aly > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > [Non-text portions of this message have been removed] >
