[rawgabbit]

     Select M.*, V.* from Measurement as M left outer join Value_table as V…

You end up with nulls again.

[recursive]

Yes. That's part of the semantics of outer joins.

But there is no stored null representing 'no value'.