Re: How to outer join columns with null value

Hi John
You just have to made an UNION
first
Select * from t1
union
Select * from t2;
Good luck
Claire Marcoux

Pawe³ Plichta <Pawel_NO-SPAM_Plichta_at_netia.pl> a écrit dans l'article <7436tc$3pj$1_at_info.nask.pl>...
> Hi John,
> try
> select ......
> where .....
> 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 - 14:41:12 CET