SELECT * FROM SALES_RINCI WHERE KODE_KOTA NOT IN (SELECT DISTINCT kode_kota FROM SALES) OR SALES_NAMA NOT IN (SELECT SALES_NAMA FROM NAME_SALES);
CMIIW, Bowo --- In [email protected], abang sunda <[EMAIL PROTECTED]> wrote: > > 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 >
