3 ms·

Select M.*, V.* from Measurement as M left outer join Value_table as V… You end up with nulls again.

• recursive 2y ago
  Yes. That's part of the semantics of outer joins. But there is no stored null representing 'no value'.