select ta.vendor_code,ta.vendor_name,ta.curr,ta.amount Amount
A,nvl(tb.amount,0) Amount B
from transA ta,
transB tb
where tb.vendor_code(+) = ta.vendor_code
and tb.curr (+) = ta.curr
________________________________
From: "[email protected]" <[email protected]>
To: [email protected]
Sent: Tue, November 17, 2009 12:03:48 PM
Subject: Re: [indo-oracle] Tanya query SQL
sorry ini view yg akan di cari , yg tadi salah ketik (penempatan) ...mohon
maaf
di group ini gak bisa send email with attacment file yah ( kemarin gambar
table dan view capture )
oke saya ketik manual
Table : Vendor
Vendor Code Vendor Name
A01 PT. ABC
A02 PT. DEF
A03 PT. GHI
A04 PT. JKL
A05 PT. MNO
Table : Trans A
Vendor Code Vendor Name Curr Amount
A01 PT. ABC IDR 20,000
A01 PT. ABC USD 234
A02 PT. DEF IDR 30,000
A03 PT. GHI IDR 40,000
Table : Trans B
Vendor Code Vendor Name Curr Amount
A01 PT. ABC IDR 70,000
A03 PT. GHI IDR 25,000
A03 PT. GHI USD 251
A04 PT. JKL USD 271
View : ABC ( view yg dicari )
Vendor Code Vendor Name Curr Amount A Amount B
A01 PT. ABC IDR 20,000 70,000
A01 PT. ABC USD 234 0
A02 PT. DEF IDR 30,000 0
A03 PT. GHI IDR 40,000 25,000
A03 PT. GHI USD 0 251
A04 PT. JKL USD 0 271
eko putra <ekoputra2007@ yahoo.com>
Sent by: indo-oracle@ yahoogroups. com
11/16/2009 08:57 PM
Please respond to
indo-oracle@ yahoogroups. com
To
indo-oracle@ yahoogroups. com
cc
Subject
Re: [indo-oracle] Tanya query SQL
ini mau buat view "tabel-tabel di bawah ini" .. Mana table-nya..?
____________ _________ _________ __
From: "ali.ak...@kawasaki. co.id" <ali.ak...@kawasaki. co.id>
To: indo-oracle@ yahoogroups. com
Sent: Fri, November 13, 2009 5:42:59 PM
Subject: [indo-oracle] Tanya query SQL
Haloo brother's
Untuk menghasilkan VIEW : ABC dari tabel-tabel di bawah ini
gimana yah SQL nya :
Thanks sebelumnya.
Ali Akbar
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
