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

In article <3A23C1D4.BAEA3151_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

Actually, you can write complex outer join condition using AND and OR. I suspect this is a question from some OSP preparation course, there are lots of bugs in them. Of course, AND and OR are not conditional operators, looks like it's a real meaning of the question.
> 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!
> ========================================
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 15:28:24 CST