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:

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

Original text of this message