SQL Join on NULL column value

It happens many times that, while designing the table structure, we allow NULL for some of the columns and then later on we get the need to perform the join on Null column values to retrieve the required result-set. One example to think of is the sal...