all, mo minta tolong query sbb : drop table NAME_SALES;
CREATE TABLE NAME_SALES (SALES_ID NUMBER, SALES_NAMA VARCHAR2(4)) / insert into NAME_SALES values(1,'ANDI'); insert into NAME_SALES values(2,'BUDI'); insert into NAME_SALES values(3,'CICI'); commit; drop table SALES; CREATE TABLE SALES (SALES_ID NUMBER, SALES_AMNT NUMBER, KODE_KOTA NUMBER) / insert into SALES values(1,10000,22); insert into SALES values(1,20000,23); insert into SALES values(2,11000,22); insert into SALES values(2,21000,23); insert into SALES values(3,31000,23); insert into SALES values(3,31000,23); commit; drop table SALES_RINCI; CREATE TABLE SALES_RINCI (KODE_KOTA NUMBER, RINCI_AMNT NUMBER, SALES_NAMA VARCHAR2(4)) / insert into SALES_RINCI values(22,9999,'ANDI'); insert into SALES_RINCI values(24,8888,'ANDI'); insert into SALES_RINCI values(24,9999,'BUDI'); insert into SALES_RINCI values(22,9999,'CICI'); insert into SALES_RINCI values(23,9999,'DIDI'); commit; sudah google tp gak nemu2. yg dibutuhkan adalah keluar semua rows yg ada. macetnya di ngeluarin 'DIDI' dan kode kota 24, yg masing2 tidak ada pasangannya di table lain. terima kasih ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265
