SELECT DISTINCT a.data_uid, ABS(a.amount-b.amount) amount FROM (SELECT data_uid, SUM(amount) OVER (PARTITION BY data_uid ORDER BY 1) amount FROM table_1)a, (SELECT data_uid, SUM(amount) OVER (PARTITION BY data_uid ORDER BY 1) amount FROM table_2)b WHERE a.data_uid = b.data_uid AND a.amount != b.amount;
hth, AH aly rmb wrote: > > ini maa, hasilnya sama, ama queri-nya p'Ferry :( > > Antonius Bayu <[EMAIL PROTECTED] <mailto:bayu_9484%40yahoo.com>> > wrote: Hi. mungkin query ini bisa dicoba > > select a.data_uid,sum( nvl(a.amount, 0)) -sum( nvl(b.amount, 0)) > from table1 a,table2 b > where a.data_uid = b.data_uid > group by a.data_uid > > CMIIW > > ----- Original Message ---- > From: aly rmb <[EMAIL PROTECTED] <mailto:aly_rmb%40yahoo.com>> > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Sent: Wednesday, May 7, 2008 2:05:20 PM > Subject: Re: [indo-oracle] Compare 2 table > > Sebelumnya, terimakasih atas responnya, > Tadi sebelum tanya, sudah sempat coba queri ini, cuma hasilnya tidak > sesuai, > misal : > table_1 > data_uid amount > ------------ ----------- > 3 5 > 3 14 > > table_2 > data_uid amount > ------------ ----------- > 3 5 > dgn queri di bawah hasil amountnya = 9, sedang yg di inginkan : amount > = 14 > > slm/Al > >
