Getting null values while joining tables

[Sumit2504]

Hi All,

I've two tables.

1st table Contains two fields, Bill number and Bill category.

2 table is fact table containing Bill number and Document number

while joining table 1 and fact with Bill number. I am getting null records when using Document number and bill number in a table box.

My requirement - Convert null records into values so that there's always a bill number for every document number.

Can anyone please help here.

[abhijitnalekar]

Hi @Sumit2504,

I would suggest using apply map functionality to get the document number.

With the apply map you can also set the default value which is not present into the respective table.

 Also share the data if possible so I can show the example.

[Gusikowski]

As we have seen from the above examples joining NULL values does not work. Even though you have two NULL values SQL Server does not treat these as the same value. Internally a value of NULL is an unknown value and therefore SQL Server does not equate an unknown value being equal to another unknown value.

Liteblue