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

Comments inline....

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 an outer join condition. Could some one
> give examples of how to use "IN" in outer join and what kind of error

The IN operator is very similar to an equals operator. It's just saying that one column has values equivalent to those found IN the following list.

> "AND" and "OR" would generate in an outer join condition?

You won't get an easy answer out of me for this one. Why don't you try to put the AND or OR operator in an outer join. What kind of error do you get? This is too easy for you to do for me to give the answer to you.

Download a copy of Oracle from Technet and put it on your machine and try this out yourself. Learning how to answer your own questions is the most powerful tool that a DBA can develop!

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================