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 -> SQL join to identify missing records?

SQL join to identify missing records?

From: Susie Grace <hlng_at_usa.net>
Date: Thu, 24 Aug 2000 03:39:14 GMT
Message-ID: <8o25cv$a4i$1@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 Wed Aug 23 2000 - 22:39:14 CDT

This message: [ Message body ]
Next message: Zbigniew Sliwa: "Re: SQL join to identify missing records?"
Previous message: ap: "Problem with DESIGNER 6.0"
Next in thread: Zbigniew Sliwa: "Re: SQL join to identify missing records?"
Reply: Zbigniew Sliwa: "Re: SQL join to identify missing records?"
Reply: Michel Cadot: "Re: SQL join to identify missing records?"
Reply: faheemrao_at_my-deja.com: "Re: SQL join to identify missing records?"
Reply: Mike Dwyer: "Re: SQL join to identify missing records?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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