Re: How to outer join columns with null value

Hi John,
try
select ......
where .....
[Quoted] nvl(t1.col2,'&&&&&&')=nvl(t2.col2,'&&&&&&') .... ;

'&&&&&&' - it is nonsense value, not exist in right values; Do you think of preformance?

Pawel

Big John napisa³(a) w wiadomo¶ci: <7431v0$4kj6_at_news.hk.linkage.net>...
>Hi,
> Suppose I have two tables t1 and t2, both of them have a few varchar2
>columns like the followings:
>
>t1: col1 varchar2(5), col2 varchar2(5), col3 varchar2(5)
>t2: col1 varchar2(5), col2 varchar2(5), col3 varchar2(5)
>
>Now I have to outer join the two tables by using t1.col1=t2.col1 and
>t1.col2=t2.col2. However, it cannot return the records that in case col2
>both in t1 and t2 are null.
>
>Any suggestion please. Thanks in advance.
>
>Best Regards,
>John
>
>
Received on Wed Dec 02 1998 - 12:02:08 CET