Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Empty row comes when ever joining of two tables happens with Null values

539413Oct 13 2006 — edited Oct 13 2006
Hi All,

I have created two tables in Oracle named table1 and table2..Table 1 has column ID of integer datatype with values 1,2,3 and 4. Table2 has column ID of integer datatype with values 1,NULL. If i use below query then empty row is coming..


select * from table1 where ID not in (select ID from table2)

Help me on this...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2006
Added on Oct 13 2006
6 comments
876 views