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
X
Y
Z
X
Z
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 ZReceived on Wed Dec 31 1997 - 00:00:00 CET