Re: What's Outer Join?

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/12/31
Message-ID: <68c814$h0m$1_at_marri.bs.wa.gov.au>#1/1


ªü´ö Thenardier wrote in message <34a833a2.731881_at_news.netvigator.com>...
>
>As title. And in some SQL statement used in Oracle,
>i can see WHERE TableA.Col1 = TableB.Col1 (+) or
>sth like WHERE TableA.Col1 (+) = TableB.Col1 .
>What do they mean?
>

Let us say we have two tables - 'A' and 'B' Select * from A;

COLUMN1



X
Y
Z

Select * from B;

COLUMN1



X
Z

Select A.COLUMN1 A_COL1, B.COLUMN1 B_COL1 from A, B
where A.COLUMN1 = B.COLUMN1;

A_COL1 B_COL1

------             ------
X                 X
Z                 Z

Select A.COLUMN1 A_COL1, B.COLUMN1 B_COL1 from A, B
where A.COLUMN1 = B.COLUMN1 (+);

A_COL1 B_COL1

------            ------
X                X
Y
Z                Z
Received on Wed Dec 31 1997 - 00:00:00 CET

Original text of this message