Re: HELP! Oracle Won't Let Me Outer Join...

From: contrapositive <contrapositive_at_hotmail.com>
Date: Thu, 11 Apr 2002 18:47:06 -0400
Message-ID: <3cb6169c$1_3@nopics.sjc>

"Mark D Powell" <mark.powell_at_eds.com> wrote in message news:178d2795.0204090938.72bd4273_at_posting.google.com...

> I would like to test this before I open my mouth, but being pressed
> for time have you tried performing the concatenation in an inline view
> and then outer joining the inline view to the target?
>

Tried it (per your suggestion) but suffered a HUGE performance hit. I ended up revisiting the business rules, and it turns out they're able to do without the outer join -- i.e. there should ALWAYS be an invoice. Still would have liked to have worked it out though -- strange things happen.

Thanks again for your help... Received on Thu Apr 11 2002 - 17:47:06 CDT