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

Home -> Community -> Usenet -> c.d.o.server -> Re: External join

Re: External join

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 13 Nov 2001 15:18:19 GMT
Message-ID: <3bf137cb.580244812@news.alt.net>


On Tue, 13 Nov 2001 14:43:52 +0100, "Sylvain BOURDETTE" <sbourdette_at_danet.fr> wrote:

>What is the syntax for an external join on Oracle 8i ?
>
>

Do you mean an OUTER JOIN?

You need to use the (+) operator on the column of the table for which NULLS are to be returned when it does not match a value in the other table, in the WHERE clause of your query where you join the two tables.

SELECT

	A.Id,
	B.Value
FROM
	A,
	B
WHERE
	A.Id = B.Id(+);

It may be best to read about it in:
Oracle8i SQL Reference
Chapter 5: Expressions, Conditions, and Queries Section: Queries and Subqueries
Sub-section: Joins
Sub-Sub-Section: Outer Joins
<URL:http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/expressi.htm#1002893>

Brian Received on Tue Nov 13 2001 - 09:18:19 CST

Original text of this message

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