Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External join
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