Re: SQL join to identify missing records?

From: Zbigniew Sliwa <zibi_at_at_hotmail.com>
Date: Thu, 24 Aug 2000 07:00:32 GMT
Message-ID: <kK3p5.10956$Yl4.249148@news.tpnet.pl>

Susie,

You can use outher join:

SELECT table1.id

FROM      table1,
          table2
WHERE     table1.id = table2.id_table1(+)
AND       table2.id_table1 IS NULL

Good luck!

---

Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com

Susie Grace napisa³(a) w wiadomo¶ci: <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:00:32 CDT