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 <[email protected]> Sent by: [email protected] 11/16/2009 08:57 PM Please respond to [email protected] To [email protected] cc Subject Re: [indo-oracle] Tanya query SQL ini mau buat view "tabel-tabel di bawah ini" .. Mana table-nya..? ________________________________ From: "[email protected]" <[email protected]> To: [email protected] 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]
