I have a select query in Oracle like the followings. The query brings up the matching records have both TBL1.col2 and TBL2.col2 not equal to null. But if the records have null values in both TBL1.col2 and TBL2.col2, it won't bring up the records. Is there any work aroud? I need to show them as well.
From TBL1 left join TBL2
on TBL1.col1=TBL2.col1 and TBL2.col2=TBL2.col2