Saya coba menolong anda.
ada 3 cara :
select abc.nomer,abc.nama from def,abc
where def.nomer(+)=abc.nomer
and def.nama(+) = abc.nama
and def.nomer is null
select * from abc
where (nomer, nama) not in (select * from def)
select * from abc
where not exists (select * from def where nomer=abc.nomer and nama=abc.NAMA)
semoga dapat membantu...
regards,
Iwan...
sandi <[EMAIL PROTECTED]> wrote:
rekan2, saya mohon bantuannya
saya create 2 table
create table abc (nomer varchar2(5), nama varchar2(5));
insert into abc values ('1','a');
insert into abc values ('2','b');
insert into abc values ('2','c');
COMMIT;
create table def (nomer varchar2(5), nama varchar2(5));
insert into def values ('1','a');
insert into abc values ('2','d');
insert into def values ('3','c');
COMMIT;
saya ingin menampilkan data di table abc yang tidak ada di table def.(dengan
parameter field nomer dan nama yang sama tidak ditampilkan, tapi kalo salah
satu field saja yang sama lainnya tidak sama, tetap ditampilkan)
dalam kasus diatas hasil yg saya inginkan adalah :
NOMER NAMA
2 b
2 c
saya harapkan bantuan rekan2 milis. terimakasih
budi
______________________________________________________
by Bidang Perencanaan - Sub bidang Teknologi Informasi
PT PLN (Persero) Distribusi Jawa Timur
* Saran & Kritik E-mail ke [EMAIL PROTECTED]
* Telp. (031) 5340651-6 Ext. 813
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
Membership database software Database mortgage software Pda database software
Database management software Oracle database administration Oracle database
management
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indo-oracle" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
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/
