select a.data_uid,sum(nvl(a.amount,0) - nvl(b.amount,0)) from table1 a,table2 b where a.data_uid = b.data_uid group by a.data_uid
regards Ferry 2008/5/7, aly rmb <[EMAIL PROTECTED]>: > > 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 > [Non-text portions of this message have been removed]
