Re: Outer join problem

From: s. hunter <sarahxhunter_at_NOSPAMTHANX.hotmail.com>
Date: Thu, 10 Feb 2000 16:14:20 +0100
Message-ID: <38A2D5CC.47834A1B@NOSPAMTHANX.hotmail.com>

Rock,

It was:

SELECT nvl(a.seqid,'12345'), b.description, nvl(a.numerical_column,0) from a, b
where a.catid(+)=b.catid
and a.seqid(+)='12345'
order by b.description
/

It takes a very long time to execute though.. probably because of the outerjoins. I'm still going to try and write a PLSQL solution. (I've almost finished.)

/Sarah

rockcogar wrote:

> So what was the SQL of the final solution ?
>
> Rock.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Feb 10 2000 - 09:14:20 CST