Bung AH,
ini yg di tunggu*, sesuai inisialnya "AH" , querinya sudah di coba dan
tokcher.
terimakasih banyak sudah banyak membantu dan terimaksih juga pada yg sudah
merespon.
btw, mungkin bung AH punya Blog mengenahi SQL, yg bisa di share ke kita ? :)
slm/Al
Awaluddin Hamid <[EMAIL PROTECTED]> wrote:
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
>
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
