Re: AND, OR can not be used in an outer join condition?

From: <yong321_at_yahoo.com>
Date: Tue, 28 Nov 2000 05:34:17 GMT
Message-ID: <8vvg4p$20g$1@nnrp1.deja.com>

SQL> select * from all_honda;

MODEL

Accord
Civic
Prelude
Odyssey

SQL> select * from honda_year;

MODEL YEAR
---------- ---------

Accord             1
Accord             2
Civic              3
Prelude            4

SQL> select a.model, b.year from all_honda a, honda_year b where a.model = b.model (+);

MODEL YEAR
---------- ---------

Accord             1
Accord             2
Civic              3
Odyssey
Prelude            4

SQL> select a.model, b.year from all_honda a, honda_year b where b.model (+) in (a.model);

MODEL YEAR
---------- ---------

Accord             1
Accord             2
Civic              3
Odyssey
Prelude            4

I'm not sure how you can use AND and OR in an outer join.

Yong Huang
yong321_at_yahoo.com

In article <8vv8me$sl9$1_at_nnrp1.deja.com>, gmei_at_my-deja.com wrote:
> Hi:
>
> I am trying to understand the following question:
>
> Q: Which two operators can not be used in an outer join condition?
>
> a. =
> b. IN
> c. AND
> d. OR
>
> Answer is c and d.
>
> I understand "=" can be used in outer join condition. Could some one
give
> examples of how to use "IN" in an outer join and what kind of
error "AND"
> and "OR" would generate in an outer join condition?
>
> Thanks.
>
> Guang

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 27 2000 - 23:34:17 CST