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