Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL join to identify missing records?

Re: SQL join to identify missing records?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 24 Aug 2000 09:37:59 +0200
Message-ID: <8o2jf8$3vf$1@s1.read.news.oleane.net>

Assuming you have two tables joined by column id: table1(id, ...)
table2(id, ...)
the records in table1 that are not in table2 are given by: select distinct id from table1
minus
select distinct id from table2
/

--
Have a nice day
Michel


Susie Grace <hlng_at_usa.net> a écrit dans le message : 8o25cv$a4i$1_at_nnrp1.deja.com...

> I have 2 tables that are joined, and want to identify records that are
> in table1 but NOT in table2?
>
> What is the sample syntax?
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 24 2000 - 02:37:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US