How to outer join columns with null value
From: Big John <johnnyngan_at_yahoo.com>
Date: Wed, 2 Dec 1998 17:39:17 +0800
Message-ID: <7431v0$4kj6_at_news.hk.linkage.net>
Hi,
[Quoted] Suppose I have two tables t1 and t2, both of them have a few varchar2 columns like the followings:
Date: Wed, 2 Dec 1998 17:39:17 +0800
Message-ID: <7431v0$4kj6_at_news.hk.linkage.net>
Hi,
[Quoted] 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 - 10:39:17 CET