select table1.column_id,
table1.column_type,
table2.column_name
from table1
left outer join table2
on table1.column_type = table2.column_numb
In Table 1
column_id column_type
1 NULL
2 NULL
3 300
In Table 2
table2_column_id column_numb column_name
1 100 ABC
2 200 DEf
3 300 GHI
Expected value
column_id column_type column_name
1 NULL NULL
2 NULL NULL
3 300 GHI
My query is not picking the NULL Values. What could be the reason ??
i implemented same logic query in my production database, but records with null value is filtered.