Re: double outer join

From: Isaac Blank <izblank_at_yahoo.com>
Date: Thu, 12 Jun 2003 20:46:58 GMT
Message-ID: <6F5Ga.407$nX7.32073772@newssvr15.news.prodigy.com>

A couple of alternative hints:

Try using a standard SQL join syntax and decide what kind of a join you need. This will only work if you are using Oracle 9.
Alternatively, look up "table pivoting"

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EE8E517.1785C15_at_exxesolutions.com...

> This is classroom homework so I'll give you a hint rather than the
> answer.
>
> You are on the right track but think about NVL and how you might use it.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Thu Jun 12 2003 - 15:46:58 CDT