Kalau pakai SQL*Plus SQL> BREAK ON NOMOR# SQL> SELECT s.NOMOR# , s.KODE, s.NAMA_BRG, s.RUPIAH, d.KODE, d.NAMA_BRG, d.RUPIAH FROM table_satu s, table_dua d WHERE s.NOMOR# = d.NOMOR# ORDER BY s.NOMOR#;
Bowo --- In [email protected], tory byantoro <[EMAIL PROTECTED]> wrote: > 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/
