Re: need a SQL finesse...

This is assuming that column 3 in both table A and B are the join.

Below is only work for cases where there are cases present in table a but may not /may present in table b.

select a.*,b.* from
a,b where a.3 = b.3(+);

Below is only work for cases where there are cases present in table b but may not /may present in table a .

select a.*,b.* from
a,b where a.3(+) = b.3;

"alan" <alan_at_kenamea.com> wrote in message news:39a5cbd8.34199646_at_news.pacbell.net...
> I have 2 tables A and B
>
> A has 4 columns 1,2,3 and 4
>
> column 3 refers to table B
>
> I wish to perform a single select statement (in order to put the
> result in a cursor and return it from the stored procedure)
>
> which resolves the reference in column 3 if it is not null, but -
> obviously - does not attempt to do so if it is null.
>
> This is my problem simplified down to its barest bones. I know there
> must be a solution but it is beyond my limited experience.
>
> TIA
>
> alan
Received on Fri Aug 25 2000 - 04:19:25 CDT