DH,
Mohon pencerahan, saya punya dua table yaitu,
TABLE SATU
NOMOR# KODE NAMA_BRG RUPIAH
CA123 P501 PAKET BUAH 7500
CA124 M501 MANGGA 1600
CA124 D501 DURIAN 1700
CA124 N501 NANAS 1800
CA125 J501 JAMBU 1900
TABLE DUA
NOMOR# KODE NAMA_BRG RUPIAH
CA123 J501 JAMBU 2000
CA123 B501 BELIMBING 1500
CA123 N501 NANAS 1500
CA124 A501 ANEKA BUAH 5750
CA125 E501 ES JAMBU 2500
Relasi-> Table Satu & Table Dua adalah Nomor#
Hasil query yang diharapkan,
NOMOR# KODE NAMA_BRG Rp KODE NAMA_BRG Rp
CA123 P501 PAKET BUAH 5500 J501 JAMBU 2000
B501 BELIMBING 1500
N501 NANAS 500
CA124 M501 MANGGA 1600 A501 ANEKA BUAH 5700
CA124 D501 DURIAN 1700
CA124 N501 NANAS 1800
CA125 J501 JAMBU 1900 E501 ES JAMBU 2500
Terima kasih
tory
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
